Create WoW for multi measures/Calculations in pivot table

Hello @yingkz !

If I understand correctly, do you want the GroupBy/Column of your pivot table to read like this:

01/January | 02/January | 03/January | 04/January

As of right now I don’t believe there is a truncDate / formatDate option to accomplish this, but a potential workaround could be to use the solution provided below. It will list the week number: