i am generating a pivot table to get total counts.. is there away to show the percentage of the count in another column??
at present these are the 3 columns i want to calculate the percentage of each count and display...plz some one help me...
thank you in advance
as shown in this pic for each even i need to show the percentage this is the exact table i need to generate.. omg i just saw my mistake it should be the percentage... m soooo sorry
I don't have any good data to try to mock this up, could you share your data if you scrambled the destination?
you'd need to do something like count(events)/count(total events), but maybe with some set analysis it would be easier to control it