I have the following issue
Fact1 is the head fact table with a linked DimDate dimension see below.
I want to create a straight table object that compares Amount_fact1, Amount_fact2 and Amount_fact3 bases on de date selection in the DimDate dimension. Can I solve this with Set Analysis in all the expressions?
Selections: (18-5-2015 - 24-5-2015)
Year = 2015
Month = sep
Week = 21
Product = VPB