4 Replies Latest reply on Jan 31, 2018 4:47 PM by Robert Angel

    How to avoid Fiscal Time repeating in table view?

    4514f542-29aa-40f3-a4ed-cf209af82e44

      Hi Community!

       

      I am trying to create an analysis that has Actuals, Budget and Last Year lined up by time metric. I have renamed column headers to separate the metrics I want to look at. However, the Quarters are duplicating (see screenshot below). Is it possible to have the results shown so the Quarters only appear once (i.e. the actuals and budgets line up with the LY column)? I have tried pivoting without any joy. The group who set up the tool for my company aren't around to assist unfortunately.

       

      Any help would be really appreciated!

       

       

       

      Thanks,

       

      PH