Discussion Board for collaboration related to QlikView Deployment.
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?
Go to Solution.
You can use a calculated dimension with a expression like
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.
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.
Thank you! It works!
Is possibile to change value in red circles in other value?
100 -> First
200 -> Second
300 -> Third
Try this one:
=Pick(Left(cdc, 1), 'First', 'Second', 'Third', 'Fourth', 'Fifth', 'Sixth', 'Seventh', 'Eighth', 'Ninth')