hi friends. i have total sales.how can i find sales%?

[#1]

hi friends. i have total sales.how can i find sales%?

[#2]

Hi,

If you want to represent the sales as a % of the total sales in a straight table, go to "Expression" tab, select the "sales" measure and check the "Relative" option.

Cheers

Prasan

[JonnyPoole]

on the expression tab, try checking 'relative' . It should work fine if its just a % of total you are after. 

ex:

[jagan]

Hi,

Try like this

Dimension: Product, Region or etc.

Measure: Sum(Sales)/Sum(Total Sales)

and in Number tab select Show in %.

Regards,

Jagan.

[#5]

thank you every one.

[JonnyPoole]

deven, consider closing out the thread with designated correct or helpful answers so that others can find this solution when they have the same question