on 12-04-2015 12:49 PM
Hello All,
Need quick help on getting sum functionality. Guess a context issue but still unable to figure out the solution
I have created a variable which gives me sum(v1+v2) foreach Dimension-A
I have another Dimension B.
sum(v1+v2) foreach Dimension-A = XX -->224
sum(v1+v2) foreach Dimension-B= XY -->308
All I need is to display in report is sum(v1+v2) which is XY
In report, All i need to see is 308. When I just drag sum(v1+v2) foreach Dimension-A still I get 224.
How to get this.
Thanks,
Harsha
Did you try :
=Sum( ([v1]+[v2]) ForEach ([Dimension-B]) )
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I´m sorry but I didn´t understand your question, can you provide us with some sample data ?
You don´t need to redefine the context if A and B are in the same block of the sum(v1+v2).
You need to use the ForEach if A or B isn´t in the block.
Regards,
Rogerio
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Rogerio,
Now, there are no Dimensions. Only Sum needs to be displayed in a individual cell.
I need 308 to be displayed
Also, below 2 fields are in 2 report tabs.
Tab 2------- sum(v1+v2) foreach Dimension-A -->224
Tab 1------- sum(v1+v2) foreach Dimension-B-->308
Now, in Tab 2, in a single cell I need 308.
Thanks,
Harsha
User | Count |
---|---|
80 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.