Forum Discussion

Omega's avatar
Omega
Icon for Impactful Individual rankImpactful Individual
7 years ago

Drag budget again. In the fields pane, click on the arrow next to budget, choose show value as and then choose Percent of Grand total 

 

JurajSiska's avatar
JurajSiska
Frequent Visitor
7 years ago

Hi Omega,

 

this helped for creation of the table, many thanks for that. Is there any way I could use these percentages in other visuals please?

 

Thanks,

  • Omega's avatar
    Omega
    Icon for Impactful Individual rankImpactful Individual
    7 years ago

    You can apply same trick for other visuals :)

    • JurajSiska's avatar
      JurajSiska
      Frequent Visitor
      7 years ago

      l've actually been splitting these number further by year and wanted to see a proprtional development YoY - to do this I used Show value as -> Percent of Column Total. This did the trick in the table.

       

      Now, as 2019 has only just begun I cannot compare on the grand total with 2018 for the obvious reasons, but I still can compare how much budget goes to each mean proportionally. And I'd love to do this in a line chart (i.e. see development of Incentive going from 90% in 2018 to 60% in 2019), but there I cannot add the budget field second time, and show value as only offers Percent of Grand total, which again does not show what I need to see.

       

      Am I being clear?