Displaying the percentage in pivot table

[#1]

HI

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

[#2]

Are you trying to show the average of the count on that certain date?  What is the average of?

[#3]

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

[#4]

Are you trying to show for each destination, what % of events it accounts for on that day?

[#5]

for each destination the total number of events are shown and i need to take the percentage of each destinations total percentage of events

[Clever_Anjos · Accepted solution]

You can make a %column using

sum(value) / sum(TOTAL value)  - % of whole total

sum(value) / sum(TOTAL <dim1> value)  - % of total of dimension1

[#7]

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

[hectorvega]

Or you could use :

a) Column(1)/Column(2)

b) [column-name1]/[column2-name]

[#9]

i tried this but i am not getting a correct answer i think

[#10]

oki i got this working can you tell me how can i reduce the decimal points up to two points??