Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have one calculated dimension which is a complex
IF(match( pick(1+match(...,...,...,...
Let's called this calculated field: Field1
I would like to have a second calculated dimension which is further filtering the Field1 : if the sum of Revenues for one value of Field1 is more than 10k, keep the value, else drop it.
How could I achieve so?
Many thanks in advance
Create this field in the script and after that will be easy filter the revenues grater than 10k in charts
I cannot use the script but only the calculated dimension in a pivot or straight table. many thanks
If you use that kind of calculated dimension and create a new one base on other calculated dimension will affect a lot the performance of your document.