Hide null expression records in pivot table

[#1]

Hi All,

I have a requirement where I have to show under performing stores for a month based on a sales condition.

I have attached a sample qvw with data. If user select a month, he should be able to see under performing stores for that month.

if sum(sales)<5 then store is consider as under performing store.

In my example if user selects feb month, he should see store s2, s3 however as per my expression, he is seeing s1, s2 and s3.

Please help me finding a solution for this requirement.

Thanks,

Anosh

[karthikeyan1504]

Hi Anosh,

Please replace your dimension as =if(Aggr(Sales,Store)<5,Store,null()) instead of 'Store' and check suppress when value is null option.

Please find the attached qvw file.

Warm Regards,

Karthikeyan A R.

[#3]

Hi Karthikeyan,

Thanks for your solution. It was quick. I just modified your calculated dimension as

=if(Aggr(sum(Sales), Store)<5, Store, null()) to get the correct result if 1 month is selected but if user selects more than 1 month or doesn't select any month, there is no data being displayed in chart. I would still want to show all under performing stores even if their sales are <5 for one month.

Thanks,

Anosh

[stabben23]

Hi,

if you want to hide dimensions, use set analysis instead of trix with dimensions.

sum({$< Sales={"<5"}>}Sales) should do your jobb.