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%. What I need is the latest data to add up to 100% and the previous data to add up to 100%. E.g., the latest medium data should be around 25.4% and the previous medium should be around 27.8%.

 

Need Help

2 Replies

  • 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?