Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to create two new rows "total" in the positions that I have indicated in the figure. The table is a table pivots.
The totals must be calculated in the following way:
Total (101,102): 1500+2590 = 4090
Total (201,202,203): 850+450+800 = 2100
How can I do?
Thanks!
Hello, Marco
You can use a calculated dimension with a expression like
=Floor(cdc, 100)
or
=Left(cdc, 1)
Put one of those expressions as your first dimension and turn on subtotals for it.
Hope it helps.
U can do it if 101 and 102 belong to another hierarchy like 100 and 201,202,203 belongs to the 200 in the same level. I mean if u have data as below.
100 101
102
200 201
202
203
If u don't have hierarchy as shown try to create one with some business logics, since u look interested in summing 101,102 and 201,202,203. If u don't have such level then I thinks its hard.
Once u have that level created u have the option in presentation tab. otherwise I guess it is not possible in Pivot table.
Regards,
Sundar
Hello, Marco
You can use a calculated dimension with a expression like
=Floor(cdc, 100)
or
=Left(cdc, 1)
Put one of those expressions as your first dimension and turn on subtotals for it.
Hope it helps.
Thank you! It works!
Is possibile to change value in red circles in other value?
Example:
100 -> First
200 -> Second
300 -> Third
...
Thanks!
...
Hi.
Try this one:
=Pick(Left(cdc, 1), 'First', 'Second', 'Third', 'Fourth', 'Fifth', 'Sixth', 'Seventh', 'Eighth', 'Ninth')