Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Is it possible to get the partial sum of dimensions in a pivot table on conditions?
For an example I have 3 dimensions and want to get the partial sums on conditional base according to the preference.
Thanks in advance.
Rgds,
Dinu1
May be you can create another 3 dummy dimensions (with blank label name) and put your Expression in Enable Conditional box. Then, Show partial sum for these 3 dummy dimensions only. But this will show extra columns in your chart. you can adjust your column width..
Instead of this, May be you can create two charts (Straight and Pivot) and show/hide based on your preference.
Edit
You can create your same 3 dimension (twice) and one with conditional based with show partial sum and another one is normal..
try the solution provided by by settu.periyasamy.. it will work..
Hi,
Thanx for your response. But in actual scenario i have more than 20 dimensions and its a ad-hoc table. So this won't be the solution that i'm looking to.
Thanx and Rgds,
Dinu1
(SUM(COLUMN NAME=('VAULE ')SALES)+SUM(COLUMN NAME=('VAULE ')SALES))-SUM(COLUMN NAME=('VAULE ')SALES)
Let us know, if you found any good solutions.
may be check the attachment..