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]

Just saw this good blog which talks about how images can help you get to your desired result. Same goes for the sample. It would be much more efficient if you can provide a sample my friend.

A picture is worth a thousand words

[Chanty4u]

try this

=aggr(sum (Total  [Failing Records]),CDE, Month)

[varunreddy]

Hi Sunny,

Hope this works

[varunreddy]

Chanty,

Not working.

Thanks for your help though

[Chanty4u]

generally

To ignore dimension in Aggr:

Example:

Aggr(Sum(value), dim1, dim2 <dim3, dim4>) where dim3 and dim4 are the dimension you need to be excludeed

[sunny_talwar · Accepted solution]

Can you try this:

Sum({<Report Date]>} Aggr(Sum({<Report Date]>} [Ruleset Failing Records]), [CDE Name], [Report Date]))

or

Only({<Report Date]>} Aggr(Sum({<Report Date]>} [Ruleset Failing Records]), [CDE Name], [Report Date]))

[Chanty4u]

try this

it will work

sum({1<Month= >} [Failing Records])

[Chanty4u]

may be

count(TOTAL <Month> [Failing Records])

or

Ignore selection in Dimension: count({$<Month=>}[Failing Records])

Ignore All Dimensions in chart: count(TOTAL [Failing Records])

[varunreddy]

Hi Sunny,

This is working. Can you explain what is the difference between this and the equation I wrote

[sunny_talwar]

Although you don't specify an outer aggregation function (such as Only or Sum or Min or Max), there is a outer aggregation that is out there. In your case Only(). If you are using a set analysis to ignore something in your inner aggregation, you need to do the same on the outer aggregation as well, else the results will be what you saw in your case.

Hope this clarify things?

Best,

Sunny