Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I would like to ask questions about pivot table.
First, is there any way to get rid of the 'value' sign in the column(as shown).
second, how can i get the average value for the others & totals (as shown)? it would make more sense to use the average value for these three columns. but i used one row so not sure how to make different expressions for measures. Thanks so much!!
not 100% but i dont think it can be removed. You will need an extension
one work around is replcing label as =chr(32) but it still shows the search icon
hi
for the first question, i don't think you can hide the value button
for the second question you can use avg function in the expression
so the total will also be avg