2 Replies Latest reply on May 3, 2018 9:30 AM by Aisling Towey

    LOD Expression - Percentage of Years

    Aisling Towey

      Hi all,

       

      I am looking for a way to solve the below problem. There is a column to the left of this data called "name" and a persons name attached to a FY17 and FY18 cell but I have left this out due to confidentiality. I am trying to turn the below figures into a percentage of total FY17 and FY18. For example I want 560 on the top line to show 5.14% which is the percentage of total FY17 figures called out (all blue bars). When I use any of the "percentage of" options I can only manage to get percentages of the overall table(including FY17 and FY18) rather than just a percentage of the FY17 rows.

       

      I feel it is an LOD calculation I need but am not sure how to do this. Any help would be greatly appreciated.

       

      Thank you,

      Aisling