Percentage of Total Straight Table

[evansabres]

I have a straight table, for which the dimension is 'BUYER TYPE CODE'

The expressions are =Num(Count({<LOCATION = {'Pavilion'}>} TICKET_ID), '#,###.') (There are nine different 'LOCATIONS')

At the bottom of each of these columns (expressions) I want to display a percentage total.

For example

BUYER TYPE          Pavilion               100 Bridge          200 Bridge

Adult                         33                         33                    33

% Total                     33%                      33%                 33%

How would I do this?

[sunny_talwar]

May be this

=Num(Count({<LOCATION = {'Pavilion'}>} TICKET_ID)/Count(TICKET_ID), '#,###.%')

[evansabres]

Would this be an expression or a dimension?

[sunny_talwar]

Expression I would think

[evansabres]

This will create another column though.

I am looking to have the bottom row of each column be a total of each event

[evansabres]

And by total, i mean the total of that column, relative to the event total.

So, if there are 100 scans in the pavilion, and there are 1,000 overall, i want to create a row showing that the pavilion is responsible for 10% of the scans

[sunny_talwar]

I don't really understand, would you be able to share a sample? If not, then may be someone else might be able to offer some help here