Set Analysis Filter Combination ?

[Anonymous]

Dear Expert,

From the Pivot Table above, I want to filter the data in Unit = A and Month = Jan & Feb.

My expectation is the display should be like this

So, the Total of Jan should be 55, Feb should be 40, and Total of Unit A should be 80.

But, if I use set analysis like Sum({<Unit-={'A'}, Month-={'Jan','Feb'}>} Qty), the result becomes

(Unit A, as well as Jan & Feb, are missing)

Please help me to find the solution for this case.

Thank you.

[MK_QSL]

Can you provide sample app here?

[kaushiknsolanki · Accepted solution]

Try this.

Sum({<Unit -= {"a"}>+<Month -={"Jan","Feb"}>}Value)

Regards,

Kaushik Solanki

[Anonymous]

Yes. Herewith I attach the sample app.

Thank you.

[Anonymous]

Thank you Kaushik. It works

[kaushiknsolanki]

Great.

Please mark a post which gave you the right answer as "Correct Answer"

Regards,

Kaushik Solanki

[Anonymous]

Great work Mr Kaushik.