Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Sum( {<Product = {'=aggr(count (distinct Grooup ),Product )=GetSelectedCount(Grooup)'} >} Vol)
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
??
If so try these in your expressions:
Situation1:
sum({<Product = {'Product2'}>}Vol)
Situation2:
sum({<Product = {'Product2','Product3' }>}Vol)
it's too easy situations
For example I'm choosing the D and C in the filter
if( Count( Total <Product> Product)=Count(TOTAL DISTINCT Grooup) ,Sum( Vol),0)
It's my idea, but I look for another
Sum( {<Product = {'=aggr(count (distinct Grooup ),Product )=GetSelectedCount(Grooup)'} >} Vol)