Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
So I am trying to build a pivot table while calculating the percentage based on the selected SecondaryDimensionality() and the "SecondaryDimensionality" function does provide how many secondary dimensions added in the pivot but it does not provide what are those dimension.
Right now my expression sounds like this:
I would like to be able to make this equation dynamic, using a function if possible or any other mean.
Thanks
To make dynalic, How you will be producing into dynamic of ignore fields?
Table are not supposed to be filtered by any selection if this what you mean