Pivot demension conditions

[tomcatxx]

Hi, there. I have a sample question.

I just want to show a part of data in Pivot table.  Coditions is   Demension1 >= Today()-60, Demension2 <> 'A' und Demension2 <> 'B'.

Can u help me write that statemant? Thank you.

[Anonymous]

How about using set analysis such as:

=sum({Demension1={">=$(=Date(Today()-60))"},[Demension2]-={'A','B'}>} Value)

[sunny_talwar · Accepted solution]

You have all both these dimensions within your pivot chart? Also, what is your expression... it will be better to add them as set analysis rather than calculated dimension

Sum({<Dimension1 = {"$(='>=' & Date(Today() - 60))"}, Dimension2 -= {'A', 'B'}>}Measure)

[tomcatxx]

Yes, that's right. Thank you very much. It works now.

[tomcatxx]

Thank you for ur set Analysis. It works.