Ignore Dimension-Filter for If Statement in Pivot Table & Combo Chart

[vardhancse]

Hi,

I have one requirement, like ignore month and year filters for if condition expressions:

Expression:

IF(WildMatch(MonYY,'*18','Jan-19'),
Sum({<Type={'1'}>}Volume),
Count({<B={'1'}>}ID))

Tried:

Solution 1:

IF(WildMatch(MonYY,'*18','Jan-19'),
Sum({<Type={'1'},Year=,MonthName=>}Volume),
Count({<B={'1'},Year=,MonthName=>}ID))

Solution 2:

IF(WildMatch(MonYY,'*18','Jan-19'),
Sum({1<Type={'1'}>}Volume),
Count({1<B={'1'}>}ID))

but no luck

can any one let me know any solution for the same

[sunny_talwar · Accepted solution]

Try this

If(WildMatch(Only({<Year, MonthName>} MonYY), '*18', 'Jan-19'),
  Sum({<Type = {'1'}, Year, MonthName>} Volume),
  Count({<B = {'1'}, Year, MonthName>}ID)
)

[vardhancse]

Hi @sunny_talwar ,

Worked perfectly and thank you so much, missed that point of using Only().