topic Re: Filter Pivot Columns in App Development

Filter Pivot Columns

CeeJay — Fri, 30 May 2025 13:55:19 GMT

I got this table:

and would like to create a pivot table like this:

but I would like to filter W > 0 and E < 1, like this:

I tried filtering the column, I tried filtering the measure.

Then I tried GENERIC LOAD. But I still can't filter out E > 0

Please help me

rubenmarin — Sat, 31 May 2025 07:03:44 GMT

Hi, you can try with an expression like:

Count({<ID={"=Count({<Section={W}>}ID)>0"}>-<ID={"=Count({<Section={E}>}ID)>0"}>}ID)

rafaelencinas — Mon, 02 Jun 2025 00:40:31 GMT

Hi !

You can create a new bookMark,

1 - Create two Filters with W and E

2 - In the filter W type: > 0 and type Enter

3 - In the Filter E type: < 1 and type Enter

4 - Create an BookMark

Why:

When you used expresions in filters It will work differently with selections

Bye !

CeeJay — Wed, 04 Jun 2025 14:10:11 GMT

Thank you very much, at the end I solved it by modifing the load statement.