Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a pivot table with two dimensions Memo_Key and Timezone. I want to display total calls with respect to dimensions and total but the measure Timezone efficiency should be displayed at totals only. Is there any way to hide the timezone efficiency measure for each of the timezone dimension bucket?
Use calculated dimension If(Match(Dimension,'Total Calls'),Dimension)
Can you share the expected layout please. Meantime, please share excel file with us
Try with Dimensionality() function like
if(Dimensionality()=0, count(TotalCalls), effieciency expression)