4 Replies Latest reply on Aug 7, 2018 5:51 AM by John Sobczak

    How to show total in a view when the filtered dimension is not in Row/Column?

    maomaojuno

      Hi all,

      I have a dummy data for the profit/cost ratio of project A and B. I want the lower chart to show the total profit/cost ratio of both projects when I filtered on project A only, so that I can compare project A ratio with the total. I already created a new dimension “Total Profit/Cost” = {fixed:[Profit/Cost]}, but it still doesn’t work (both charts showing project A only). I know it would work if I have "project" in column and row, but wondering if this can be done without that. Can anyone show me how to get this done? I’ve attached the packaged workbook. 

      Dummy Data.PNG