Aggregate function

[Anonymous]

sum(ValueINR) is not working correctly in pivot table

sum(valueINR is 1000000

but it show 40000 its column wise

[kaushiknsolanki]

HI,

     Please explain in detail with what you are doing. If possible also attach the sample example (QVW file)

Regards,

Kaushik Solanki

[Anonymous]

ValueINR  Region

500          south

1000        north

500           east

1500         south

200           north

700           east

700           west

this is Table Value

in pivot Table

Region

east        1200

west        700

north       1200

south      20000

but i want total value is 5100

[kaushiknsolanki]

Hi,

     So only thing is you need total in pivot table...?

     If yes then go to properties -> Presentations -> Dimensions & expressions -> select region and then check show partial sum -> click apply and ok

Regards,

Kaushik Solanki

[#5]

So you want to display for every region the total value for all regions?

[Anonymous]

yes Przemek you are right

[#7]

You can use sum(total ValueINR)

[Anonymous]

hi Kaushik Solanki i want to calculate the percent of north region so i  put formula in expression

sum(Value INR)/ sum(Value INR)/100 (ie for east region 1200/(5100/100))

Region    Value INR  percent

east        1200          23%

west        700            13%

north       1200           23 %

south      2000           39 %

[CELAMBARASAN]

Hi,

     You can try with this expression,

          (sum(ValueINR) * 100)/ sum(Total <Region> ValueINR)

Celambarasan

[#10]

You can use

sum(ValueINR) / sum(Total ValueINR)  as expression and than in the Presentation tab choose Show in percent (also choosing number or fixed to).