I have a full table, where some fields are concatenated to create keys.
These keys are linked to a second table which has values just for some of these keys.
Let say that in Table A, by concatenation I obtain 10 keys
but in Table B I actually have values associated to only 5 of these 10 keys. Let assume these 5 keys ends with AA, meanwhile the keys with no values in table B ends with BB
if I use following expression in a pivot
sum( { 1<key={' *AA'}>} value )
I get correct values just for those 5 keys
but if I use following expression
max( sum( { 1<key={' *AA'}>} TOTAL value )
then the Total sum of all the 5 values is given on ALL of the ten keys.
Previously the pivot was just showing the 5 keys with a value
Is there a way to avoid to show, by using the max/TOTAL function, the keys which actually dont have a value?
thank you!