Forum Discussion

george_o0802's avatar
george_o0802
Regular Visitor
2 years ago

Help with Data visualization, pretty please

I would like to convert the attached chart to a %. I cannot use the simple % of Grand total function as it gives me each bar as a % of the grand total such that the entire data set adds up to 100%. W...
Need Help
HarishKM's avatar
HarishKM
Super User
2 years ago

george_o0802  Hello,
Can you more detail about your requirement?

Or  you can try similer formula below.

Total sales % =
Var _sales = SUM(financials[Gross Sales])
Var _totalsales = CALCULATE(SUM(financials[Gross Sales]),ALL(financials))

Return
DIVIDE(_sales,_totalsales)


Thanks
Harish M

george_o0802's avatar
george_o0802
Regular Visitor
2 years ago

In short,
I want to present this data as a %. This is a product and this is affluence data for customers of said product in the latest time period and previous time period. I have been given the data as a raw customer number but I would like to convert this to a %. I want this chart to show what % of each period customers were in each affluence demographic group. For example, the latest period has 134k customers and 20k of those were very low affluence. I want this to be shown as a % (14.93%). For the previous period, there were 115k customers 17k of which were very low affluence and I would like this as a % of the previous period (14.78%). Thereby showing any changes in prevalence of affluence demographics.

Does this help at all?