Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am showing volume details in all the expressions used in a pivot table.
But now I need to show value(volume * Price) as a next line to the total volume(partial sum property in presentation tab).
The requirement as follows,
category | Model ID | volume |
---|---|---|
A | 1 | 100 |
A | 2 | 150 |
Total(Partial sum on category) | - | 250 |
(Requirement) Total Value | =(100*12)+(150*10)= 2700 | |
Please guide me
Try:
Sum(Volume) for the Volume calculation
and
Sum(Volume * Price) for Revenue
then use partial sum as before
Hope this helps
Hi Rupert,
As per your suggestion, I need to add a another expression which will again a separate column.
But i dont need as a separate column but to display the total value as next row to total volume
How about:
if(count(Category) = 1,
Sum(VOL),
sum(VOL * PRICE)
)
Hi Santosh,
What you are asking is not possible.
What you can do is faking. Take a Text Object and layout it similar to table and place it below the the table with the calculation you want.
Regards
Rajat
I tried this and this works fine for Table box/ straight table.
But am using Pivot table with collapse fields so displaying the text objects when collapse will be lost when field expanded.
Hi
So what you can do is go to pivot table properties, under presentation tab check for always fully expanded, if there is no specific requirement for a collapsed table.
Regards
Rajat