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

[Anil_Babu_Samineni]

You can do like below

Sum({<Action=>} [Avg Emps])

[tmumaw]

That works if you want to ignore what the user selects.

[Anil_Babu_Samineni]

You are ignoring only one variant only. Could be there must be another variant which is associate on the table. If not, Then just for identify, You mentioned ignore. What does the use on your application?

[tmumaw]

The 542 is the total for the company.  I need to measure the emp count to the company total by action.

[Anil_Babu_Samineni]

May be this?

Sum(TOTAL <Action> [Avg Emps])

If not I would suggest you to provide sample

[tmumaw]

Check this out.....

[Anonymous]

Sum(TOTAL <Year> [Avg Emps])

[Anil_Babu_Samineni]

Seems, You don't have data for this - 26 / Davey Layoff

[tmumaw]

Nope

Here is the statement:

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