Leave value out of dimension pivottable

[bartvanwetten]

Dear all,

Can someone help me out on this challenge?

If I select Source E AND W or select nothing, Contact 'Elite' should be OUT of the pivottable wich you can find in the attached qvw file.

What it does already is when i CONCAT in the formula it leaves the value of Contact 'Elite' (89.343) out of the totals wich is good in fact but the Contact 'Elite' should'nt be displayed at all.

Any help appreciated!

Thanks

Bart

[sunny_talwar]

Try this may be:

If(Concat(TOTAL DISTINCT Source)<> 'EW'

,

sum(GesamtwertZeile)

,

sum({<Kontaktkurz-={'ELITE'}>} GesamtwertZeile)

)

[Gysbert_Wassenaar · Accepted solution]

Close, but try this:

if( concat(distinct total Source)<>'EW'

,

sum(GesamtwertZeile)

,

sum({<Kontaktkurz-={'ELITE'}>} GesamtwertZeile)

)

[bartvanwetten]

Thank you guys!

Both solutions work.

Man I was close . Nice weekend folks!

@SunnyT: are you always qlicking?