Set Analysis

[Anonymous]

Hi

I want a straight table that shows weekly sales and monthly sales.  When 1 week is selected how do I get the monthly column to show the sales for the whole month to which the week belongs.

Thanks

[Gysbert_Wassenaar · Accepted solution]

Something like this if your fields are named Week and Month:

sum({<Week=, Month={'$(=max(Month))'}>}Sales)

If you have data for multiple years you might need to add the year to the set modifier too. Something like Year={'$(=max(Year))'}

[Anonymous]

Thanks very Much