Ignore dimension

[varunreddy]

Hi Guys,

I have created a bar chart.

Dimensions used:

Month

CDE Name

Expression Used:

aggr(sum(Failing Records),CDE,Month)

This is working fine. When I select a Month, the report is displaying data for one particular month. I want to ignore selections based on Month.

Is this possible?

Thanks in advance!

Kind Regards,

Varun

[sunny_talwar]

Can you try this:

Sum({<Month>} [Failing Records])

or

Sum({<Month>} Aggr(Sum({<Month>} [Failing Records]), CDE, Month))

[Chanty4u]

try

Only({<Month-={'Monthname'}>}Failing Records)

[Chanty4u]

=Only(aggr(Total <Failing Records>),CDE,Month)

[Chanty4u]

chk dis

Ignore all selections except some specific fields using Set Analysis

[varunreddy]

Hi Sunny,

This is not working

[varunreddy]

Hi Chanty,

I want to ignore any selection for Month

[sunny_talwar]

Would you be able to show a sample showing the issue? There is not other way I can think of ignoring selections.

[hcabrera]

May be:

aggr(sum({<Month=>}Failing Records),CDE,Month)

HC.

[varunreddy]

Hi Henry,

Already tried this. But it is not working