Show Column If not working as expected in Pivot Table

bschnug — Wed, 05 Jan 2022 18:49:08 GMT

I am having trouble getting the show column if function to work as expected.

I have one field "Month Year" as the columns in my pivot table.

There is a flag field that has these values (straight table to illustrate the values, not the pivot I want to modify):

As of now, the columns in my pivot table show every date:

I would like to only show columns where the value of the flag for each date is 1.

However, when I use this formula:

if(Rolling12Flag=1,1,0) or if(Rolling12Flag='1',1,0), the output only shows a blank in the column (all a single column with no field) and the data tab gives me this:

Any ideas as to why this may be the case?

Re: Show Column If not working as expected in Pivot Table

AshutoshBhumkar — Thu, 06 Jan 2022 06:38:07 GMT

Hello,

Try set analysis.

e.g Sum({<Rolling12MonthsFlag = {1}>}Sales)

This expression will give you sales values only for MonthYears where flag=1 i.e Jan 21 to Dec 21

Thanks,

Ashutosh

topic Show Column If not working as expected in Pivot Table in App Development

Show Column If not working as expected in Pivot Table

Re: Show Column If not working as expected in Pivot Table