In Pivot Table - Set Analysis for two weeks with multiple values

[#1]

Hi All,

How to achieve having three columns in one dimension & also to implement Set Analysis for two weeks.

	Current Week			Previous Week
CUST001	100	2000	1500	0	0	0
CUST002	50	1500	800	10	1000	900
CUST003	200	3500	3000	8	900	850

[Gysbert_Wassenaar]

To begin with you need a date field that can be used to determine the current and previous week. The data you posted does not seem to contain such a field.

[#3]

Please find the screenshot & the required dashboard is like below