totals in the pivot table

[kumarkp412]

Hi friends,

i am one doubt  in pivot table

how to calculate the subtotals in the pivot table with out the ticking the partial subtotals ?

Is it possible to calculate  the total,subtotal in the expression wise?

Can any one know these ,kindly please share you thoughts.

Thanks in advance

kumar

[#2]

Hi,

In Presentation tab click the sub totals on top and sub totals on bottom .

[buzzy996]

I don't think so,it possible without checking those check boxes and radio buttons.

[hic]

No, you need to tick the partial subtotals. If you write your expression correctly - using aggregation functions - the numbers will be calculated automatically.

HIC

[kumarkp412]

thank you friends,

for your reply.

Because i want to calculate the expression as the subtotal.

Is their any other way to get !

Thanks

Kumar

[hic]

Normally you don't need a second expression as subtotal, but if you want it, you can use

  If(Dimensionality()=1, <Expression1>, <Expression2> )

HIC

[sunilkumarqv]

yes u need to use aggr your exp like below

Sum(aggr(sum(value),Dimension))

[kumarkp412]

can you give me sample example.

Thank

Kumar

[kumarkp412]

can you give sample example

Thanks

Kumar