Share
ReportHi,
could someone please help? I've two branches that need to be include into the report, but don't know how to write the formula into the column area.
Thanks,
Annie
Categories:
You’re offline. This is a read only version of the page.
Hi,
could someone please help? I've two branches that need to be include into the report, but don't know how to write the formula into the column area.
Thanks,
Annie
Hi Annie,
Could you expand on what you are trying to do? Are branches a segment of your account number? If they are, there are a couple of way to do this.
You could create two FD columns in the column definition. Then use the Dimension Filter cell and list the branch. Each FD column would then filter in the branch that was defined. For example, if I have branches 100 and 200, I could use the Dimension Filter and put 100 in one column and 200 in the other. The columns would then filter in branches 100 and 200 into their respective column.
The other option would be to use a reporting tree. In the tree, you'd add two lines. In the Dimensions column, you could select 100 on one line and 200 on the other. You could then put this side by side in the columns by using the Reporting Unit cell. Double-click in this cell, select the reporting tree and then select the unit.
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,409
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (
