3 Replies Latest reply: Jun 18, 2012 2:09 PM by Francisco Saucedo RSS

    Combined time dimension

    Francisco Saucedo

      Hi everyone,

       

      I’m trying to create a table (or chart) with a dimension that combines Months and Quarters.

       

      The table should show Product Sales in the following way:

       

      Product

      Jan

      Feb

      Mar

      Q1

      Apr

      May

      Jun

      Q2

      A

      5

      3

      2

      10

      5

      6

      7

      17

      and so on


      I know that in a table I could make each column an expression; however it would be much better if I could somehow create a calculated dimension and simply place it horizontally.

       

      I would appreciate any ideas.

      Cheers!