To display the percentage in straight Table

[Anonymous]

Have a below straight  table

Product      sales

     A          3

     B          20

     c          50

The sale is the sum of Total sale , now need to have a colum in the same table showing the percentage of sales

the table should look like

Product      Sale     Sales%

     A          30          4%

     b          20          5%

      c          50          50%

the sales% should show the percentage of sales of A in the total sales

how can this be done

[swuehl]

Could you please elaborate further how you calculate your sales%, e.g why Product A results to 4%?

I assume you need to use the TOTAL qualifier (maybe with a field list and / or set Analysis), something like

=Sum(Sales) / Sum(TOTAL Sales)

[#3 · Accepted solution]

Hi SelvaPraveen,

Follow the below steps,

Step1: Write an expression like below in, Expressions tab

               Sum(Sales)/Sum(Total(Sales))

Step 2: Goto Stright Table Properties ->Number tab and set below Number format settings for above expression,

               Select 'Number'

               Check 'Show in Percent(%)'

Thanks,

Narsi

[spsrk_84]

Hi,

Create another expression called Sales% similar to Sales and check the Relative option provided.

Thanks,

Shiva