period wise grouping problem

[#1]

Hi,

i have a small issue with period wise grouping, in my pivot table i have added 'actual' data with 'actual%', if i select period one it displays correctly, but if select Period 1,2,3  the 'actual%' data displays devided/3, i want period wise data. thanks in advance.

[#2]

[vinieme12]

Please provide a more detailed description

https://community.qlik.com/docs/DOC-2380

[#4]

Hi veneeth i have an issue with selecting period wise . if i select period one the actual% value displays 100% thats right and the same way i was select period 1,2,3 it displays period1 actual% 31%, period2 33% and period3 36% like this, i want if i select Period 1,2,3 that is also display period1 100%, period2 100% and Period3 100% like this.

Plz suggest

[#5]

i have an issue with selecting period wise . if i select period one the actual% value displays 100% thats right and the same way i was select period 1,2,3 it displays period1 actual% 31%, period2 33% and period3 36% like this, i want if i select Period 1,2,3 that is also display period1 100%, period2 100% and Period3 100% like this.

[prachisangewar]

Hi,

What formula you use ?

For your requirement you should use AGGR function

e.g.Numerator :  AGGR(sum(actual),Period) (and any other dimensions you have)

Similarly for the Denominator for your % should be sum(TOTAL <Period>sum(actual))

If you share your chart logic I can suggest the exact formula to you.

[#7]

I am using 3 dimensions like Store,Period and one Calculated dim name desc.

[#8]

and this is my Expression

[vinieme12]

Add TOTAL keyword

example

SUM(TOTAL  <Periodfield>   ...........)

[#10]

it displays the same data