Ignore dimension

[tmumaw]

Hi all,

I am trying to ignore a dimension on one of my pivot tables.  See the attached images:

The column in the pivot table labeled Avg Emps should be the same as the one above.  How can I ignore the action in the bottom chart?

thanks

[tmumaw]

There are 2 employees which have a 26.  The column labeled Avg Emps should be 542 on 24, 26 and 27.  I want to calculate the % to total avg emps.

[Anonymous · Accepted solution]

Sum(TOTAL EmpCt_ZEMPCT) / Count({<EmpDays = {1}>}DISTINCT TOTAL(Date_ZWKDATE))

[Anil_Babu_Samineni]

There is no data for 26 in EmpCt_ZEMPCT. Could be fault over there?

[tmumaw]

Thanks Wallo......works perfect and thanks Anil.....for your help

[tmumaw]

Wallo,

Works great for 1 year being selected, however when I un-filter on the year I get this:

[Anonymous]

Try

=aggr((Sum(TOTAL <FISYR> EmpCt_ZEMPCT) / Count({<EmpDays = {1}>}DISTINCT TOTAL<FISYR>(Date_ZWKDATE))),FISYR,Action)

[tmumaw]

Thanks Wallo.  This was what I was looking for.  Have a great weekend.

[Anonymous]

Glad it works for you.  You have a good weekend too!