Ignoring specific filter not working on a pivot table

[asantos]

Hi!

The challenge is to have it sum Volume even though its SelectionType column is different. Here's a representation of the table as the it is:

SelectionType	Description	Revenue	Vol	Unit Price
NA	Gross Unit Price	100.0000	90.000	10.00
SimpleDisc	Unit Price	90.000	'Not showing'	'Therefore, no unit price'
NA	Vol		90.000

There's a variable governing SelectionType through button and its name is vSelection.

The first part (green) gives me the Revenue, but when trying to get the Volume sum, it gives me null.

I've tried the second portion below in blue, ignoring SelectionType filter but it doesn't seem to work:

Sum({<SelectionType= {'$(vSelection)','NA'}>}[Revenue]) / Sum({1<SelectionType= p(SelectionType)>}Vol)

Thank you!

[sunny_talwar]

You are trying to ignore selection in SelectionType field or do you want to allow it for Vol?

[asantos]

Hi, @sunny_talwar !

I need Unit Price whose SelectionType is SimplesDisc to consider the Vol, despite its SelectionType is NA.

I thought that having Vol ignore SelectionType would solve it...

[sunny_talwar]

May be this?

Sum(TOTAL {1<SelectionType = {'SimplesDisc'}>} Vol)

[asantos]

It doesn't give me a null anymore! 🙂

I believe it's getting everything now and the Unit Price is much lower that it should be. How would I now go about including a filter, considering that there is TOTAL there.

Thank you!