Value and Volume in a single table

[santhosh_k_n]

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

[Roop]

Try:

Sum(Volume) for the Volume calculation

and

Sum(Volume * Price) for Revenue

then use partial sum as before

Hope this helps

[santhosh_k_n]

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

[Roop]

How about:

if(count(Category) = 1,

     Sum(VOL),

     sum(VOL * PRICE)

)

[rajat2392]

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

[santhosh_k_n]

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.

[rajat2392]

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