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!