Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I have a pivot table which shows the current_quarter which is built like this:
I am then able to bring in the Current_Quarter into my pivot table
applymap
('Quarters_Map', num(month(Today())), null()) ASCurrent_Quarter
I then thought I would do the same for current_month which is built like this:
applymap('RunMonth', num(month(Today())), null()) AS Current_Month
However, the results come back the same in the pivot table.
RunMonth is showing 3 for June
Quarters_Map is showing 1 for Apr-June
So I do not understand why the 2 different fields are showing the same results
Can anyone make any suggestions?
Thanks
Helen
Try this for Current Quarter
Ceil(Month(Today())/3)