pivot table modification
Hi , I have created a pivot table , the way it is created
I have used the css script and i have hidden the the row shown in below image
The resultant table look like this :
my requirement is i have to concat '%'symbol to the columns which i have highlighted in below image . is there any css script ? so i can get the changes .
harish I think it would be easier if you would create that second column separately in the data, so then you could add it as second measure in the table and format as percentage. Alternatively, if I understand the data and use case properly you can add second measure in Values and make it a formula like this = Total_bucket_value / (Total_bucket_value,all(ordered_category) - this will then calculate for each value it's percentage across all categories. Then you don't need that second column grouping which you are hiding anyway. Generally speaking the best approach to be able to display value and percentage in one go is to do it as two separate values. Hope this helps.
