exception elements

[#1]

Hi

I would like to display the total products ( in group) in the table

For 1 situation -Product2

if i use filter Group, i have situation 2

we see Product2 and Product3 in table

[Anonymous]

do mean

Situation 1:

You want to see all groups A-D but only for product 2

Situation 2:

You want to see all groups A-D but only for product 2 & product 3

??

[Anonymous]

If so try these in your expressions:

Situation1:
sum({<Product = {'Product2'}>}Vol)

Situation2:
sum({<Product = {'Product2','Product3' }>}Vol)

[#4]

it's too easy situations

For example I'm choosing the D and C in the filter

[#5]

if( Count( Total <Product> Product)=Count(TOTAL DISTINCT Grooup) ,Sum( Vol),0)

It's my idea, but I look for another

[#6 · Accepted solution]

Sum( {<Product = {'=aggr(count (distinct Grooup ),Product )=GetSelectedCount(Grooup)'} >} Vol)