Pivot Table Average Calculation

[viveksairam89]

Qlikview 11 : Finding Average in pivot table , for example i have data                             

      LOAD * INLINE [

    Ranking, Name, Month, Value

    2, A,Jan,0

    5, A, Jan, 1.56

    2, A,Feb,0

    5,G,Feb,0.5

    5,G,Feb,0.76

    5,G,Feb,2.16

    4, H, Feb, 81.63

    6, I, Mar, 9.60

]; I am unable to get the correct average in my sub Total?

When i use the formula in expression Avg(Value)

Actually i should get February total average as 41.38

i am getting as 21.26

Thanks in Advance

[viveksairam89]

Thanks for the help everyone:)

[Samrithi]

Hi,

I need Avg for all the Years as below.

Year	Category1	Category2	Category3	Category4
Avg	2534.0%	786.0%	786.0%	786.0%
2017
Jan	600	700	660	300
Feb	50	50	50	50
Mar	5300%	56%	56%	56%
2018
Apr	100	140	500	900
Jan	40	40	40	40
Feb	2300%	2300%	2300%	2300%
Mar
2019
Jan	100	104	600	1900
Feb	20	20	20	20
Mar	2%	2%	2%	2%

Appreciate the above results.

[Samrithi]

Hi, 

I have 2 charts (attached) those used calculated dimensions and when I select 1 bar in 1 chart(Last 30 days) then,

2nd chart (ActInAct Customers) is also applying filter and showing blank(attched). 

I dont nees to change the 2nd chart should not reflect on any values and should show all the values.

below are the calc dimensions in 2nd chart (ActInAct Customers):

dimension:

=Aggr(if(CUSTOMER_IN_LAST_3_YEARS_IND='Y' and CUSTOMER_IN_LAST_2_YEARS_IND='N','Last 3Yrs Active but InActive Last 2yrs',
if(CUSTOMER_IN_LAST_2_YEARS_IND='Y' and CUSTOMER_IN_LAST_1_YEARS_IND='N','Last 2Yrs Active but InActive Last 1yr',
if(CUSTOMER_IN_LAST_1_YEARS_IND='Y' and CUSTOMER_IN_LAST_90_DAYS_IND='N','Last 1Yr Active but InActive Last 90days',
if(CUSTOMER_IN_LAST_90_DAYS_IND='Y' and CUSTOMER_IN_LAST_30_DAYS_IND='N','Last 90days Active but InActive Last 30days'))))
,CHK_CustID)

Measure:

count({1}CHK_CustID)  - added 1 on measure also but still not working.

Appreciate the solution.

Thanks