topic Pivottable Measurements Groups AND Condition in App Development

Pivottable Measurements Groups AND Condition

joshuahirsch — Sat, 16 Nov 2024 06:55:29 GMT

Hi there,

I'm having a question:

I want a pivot table where the user can see, if a salespartner added data, it's getting a yes ("ja"), if not its a no.
I can group these salespartners to Regions, and ONLY if EVERY sp in a region added data, there shall be a "yes" in the pivottable. Instead, as soon as there is ONE "yes" the whole region is set to "yes".

How can i fix this?

Re: Pivottable Measurements Groups AND Condition

Clever_Anjos — Mon, 07 Jan 2019 10:50:04 GMT

What is current measure expression?

Re: Pivottable Measurements Groups AND Condition

marcus_sommer — Mon, 07 Jan 2019 11:56:56 GMT

You could try something like this:

if(count(Field) = count({< Field = {'no'}>} Field), 'Ja', 'Nein')

- Marcus

Re: Pivottable Measurements Groups AND Condition

joshuahirsch — Tue, 08 Jan 2019 09:57:27 GMT

Hi, the current expression is depending on the date. Only if they added something, a date exists.

if(Count(distinct [Date])>0,'Yes','No') translated

Re: Pivottable Measurements Groups AND Condition

marcus_sommer — Tue, 08 Jan 2019 10:14:44 GMT

Maybe something like this might work:

if(wildmatch(concat(aggr(if(Count(distinct [Date])>0,'Yes','No'), Vertriebspartner), ','), '*No*'), 'No', 'Yes')

- Marcus

Re: Pivottable Measurements Groups AND Condition

joshuahirsch — Tue, 08 Jan 2019 10:27:29 GMT

Holy!
That feels like magic!

Thank you so much Marcus!