Pivot table

[#1]

Hi all,

I got 2 short questions:

1 - I build myself a pivot table containing information about Revenue and Shipments.

Dimensions = weekday

                  =  Weeks

Now I would like to be able switching between Revenue and Shipments. It now shows me the info next to each other Revenue and Shipments.

I want it to only show me Revenue but when I clikc a button or something to switch to shipments.

Start using buttons and conditional??

2 - I would like to add a 3th expressions containing the percentages per day of the week total like:

monday 20%

tuesday 10%

etc etc 100%

now i got sum(revenue)/sum(total(reveneu) but then it shows me 1% per day and all the days collected it gives me 100%. I would like to add to 100% per week and not over all the weeks.

kind regards

[marcus_sommer]

1. You could use groups for dimensions/expressions and/or use visibilty-conditions for them - perhaps per button.

2. Try: sum(total <Week> reveneu)

- Marcus

[MK_QSL · Accepted solution]

Something like this?