pivot table

[sat_tok52]

Hi Guru's,

We are using pivot table ,I wanted to show % of below repo row.I haver tied calculated dimension but it's not working.Any suggestion.

Ex: Total/Open/O/N,Total/1week percentages etc..............

attached is the screen shot.

-Sateesh

[sunny_talwar]

Only showing the output in itself isn't very helpful. A good post is a one which contain description of what is needed, some data inputs and an expected output. I am not sure how are you getting any of the numbers in your screenshot. Please provide some more details and a sample if possible.

[swuehl]

Would be easier to answer if you provide dimensions and expressions used, just like you need to define on dimension and expression tab in your chart.

If you used an expression like

=Count(ID)

You can maybe get your percentages using TOTAL qualifier with a field dimension list, maybe like

= num( Count(ID) / Count(TOTAL<repo> ID), '#0.0%', '.', ',')