Pivot Table with Set Analysis

RighettiAndrea — Sat, 16 Nov 2024 03:13:20 GMT

Hi everyone,
I need to show a measure based on the current filter selected (the year in my case), and another one based on the previous year.

Here is the pivot. As you can see, I have null values and I don't want too see them.
I've already checked the settings that seems to be ok.

Here down below my two measures.

Measure 1 (filtered year) :
Min(Fatture.Prezzo/Fatture.QtaConsumo)

Measure 2 (filtered year -1):
Min({$<Anno={$(=Max(Anno)-1)}>} Fatture.Prezzo/Fatture.QtaConsumo)

I think that there's something wrong with the second one, but I don't unterstand what.
I need to get only 1 row per measure (of course in the measure 1 there will be the year selected with the filter, while in the measure 2 the previous one).

Thanks

Re: Pivot Table with Set Analysis

jonathandienst — Wed, 19 Feb 2020 11:33:20 GMT

You didn't ask a question, so I am not sure what you are asking, Current year expression would be

Min({$<Anno={$(=Max(Anno))}>} Fatture.Prezzo/Fatture.QtaConsumo)

Re: Pivot Table with Set Analysis

RighettiAndrea — Wed, 19 Feb 2020 11:55:22 GMT

Sorry, the editor cut almost all...now I'll edit the post...

topic Re: Pivot Table with Set Analysis in App Development

Pivot Table with Set Analysis

Re: Pivot Table with Set Analysis

Re: Pivot Table with Set Analysis