Solved
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 requir...
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.
