Set analysis to ignore selections from a field but also use it in the where condition

[matthewp]

I want to do a sum set analysis that ignores selections from a field, but uses the same field as a conditional part of it.

I have tried

=IF([Month] = 'Feb',SUM({<PTYPE = {'TypeA'},[Month]>}VALUEF),SUM({<PTYPE = {'TypeA'},[Month]>}VALUEA))

But it is still changing when Feb is selected in the month

[Anil_Babu_Samineni]

May be using {1} or {1<>}

=IF([Month] = 'Feb',SUM({1<PTYPE = {'TypeA'},[Month]>}VALUEF),SUM({1<PTYPE = {'TypeA'},[Month]>}VALUEA))

[matthewp]

If i select Jan it still changes

[Anil_Babu_Samineni]

Off course, It will change. Because, You've written only Feb month of IF Condition. Now tell me your requirement

[matthewp]

I want it to sum a different value whether the month is feb or not, but also not be affected by month selection

[Anil_Babu_Samineni]

I would go Alternate states for this s

[#7]

Can you show what you want to do? A simple example?

[matthewp · Accepted solution]

I want to have a simple LINE chart.

Dimension is Month

I Solved this with:

=sum({<PTYPE = {'TypeA'},PM = {'Feb'},[Month]>}VALUEF)+

sum({<PTYPE = {'TypeA'},PM -= {'Feb'},[Month]>}VALUEA)

With PM being the same as Month but an extra field

[matthewp]

As below i solved this with:

=sum({<PTYPE = {'TypeA'},PM = {'Feb'},[Month]>}VALUEF)+

sum({<PTYPE = {'TypeA'},PM -= {'Feb'},[Month]>}VALUEA)

However this isnt working when loading in more than 1 year ( for example if they have a PTYPE of TypeA from 2015 it is still using the calculation for VALUEF for all years, not just the year they had the TYPEA

How can i add year into the analysis?

[Anil_Babu_Samineni]

I really don't know on which cases it is working. Can you tell us what was the PM over here. I meant it has Month names

How can i add year into the analysis?

=sum({<PTYPE = {'TypeA'},PM = {'Feb'},[Month], Year={''}>}VALUEF)+

sum({<PTYPE = {'TypeA'},PM -= {'Feb'},[Month], Year={''}>}VALUEA)

Can you tell, which year you want to add over there