Hi,
I have a table like this:
- TableTransaction (DateTrans, Total)
- TableWeekCY (Year, Week, DateTransCY)
- TableWeekLY (Year, Week, DateTransLY)
Example, I have a data like this:
Year | Week | DateTransCY | DateTransLY |
---|
2012 | 40 | 09/04/2012 - 09/10/2012 | 09/06/2011 - 09/12/2011 |
I want to display Sum(Total) in 2 column, that is Total for CY and LY based on Current Selection (Year and Week). How do the Expression if I made it on the pivot table?
The Output is like this:
TotalCY | TotalLY |
---|
999,999 | 999,999 |
I norm the table into like this:
- TableWeekCY (Year & '-' & Week as CodeWeekCY, DateTransCY as DateTrans)
- TableWeekLY (Year & '-' & Week as CodeWeekLY, DateTransLY as DateTrans)
Thank you.