Report Format

[Anonymous]

Hi Friends,

Like to know wether we cab acheive the below report format in pivot table

1.   I have two dimension one is salesperson and other is week.

2.   we need to see metric self genrated sales count as inverted by  week.

3.   There are few more expressions  that is not needed to be inverted.

dimension1

Expression1

Expression2

Expression3

WEEK

WW27

WW28

WW29

WW30

WW31

WW32

I want to know how can I acheve this?

Regards,

Anant

[Anonymous]

Hi  All,

Any Suggestions???

Thanks

Anant

[Anonymous]

Hi Anant,

I have occasionally succeeded in dragging the dimension rows to the top, to make them columns, and the expression-columns to the left, which makes them rows.

[marcus_sommer · Accepted solution]

If you want to mix dimension and expression within the horizontally then you need to replace the horizontal-dimension through expressions like:

sum({< Week = {27}>} value)

or depending on selections or today:

sum({< Week = {"$(=max(Week) -8)"}>} value)

sum({< Week = {"$(=max(week(today()) -8)"}>} value)

- Marcus

[Anonymous]

tried but that dont work.

Thanks