Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Maybe something like this might work:
if(wildmatch(concat(aggr(if(Count(distinct [Date])>0,'Yes','No'), Vertriebspartner), ','), '*No*'), 'No', 'Yes')
- Marcus
What is current measure expression?
You could try something like this:
if(count(Field) = count({< Field = {'no'}>} Field), 'Ja', 'Nein')
- Marcus
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
Maybe something like this might work:
if(wildmatch(concat(aggr(if(Count(distinct [Date])>0,'Yes','No'), Vertriebspartner), ','), '*No*'), 'No', 'Yes')
- Marcus
Holy!
That feels like magic!
Thank you so much Marcus!