I have a table with 3 dimensions and 3 KPIs. I want to show rows only if at least one of the KPI is not zero. Any suggestions how to solve this? I cant change anything within the loading skript, so this is not an option.
To make it a little bit more clear, I've tried to show you the possible combinations when a row shoud be shown and when not.
So in this case you shold use an IF clause in the Table chart when you add the dimension. The same check as in the load script: IF(dim1 >0 or dim2 >0 or dim3>0, dim1) and the same for the other dimensions.
And after that you should uncheck the checkbox of 'Include null values'