Pivot problem - Current Month and Current Quarter stating same

helen_pip — Fri, 07 Jun 2013 10:31:02 GMT

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()) AS

Current_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

Re: Pivot problem - Current Month and Current Quarter stating same

er_mohit — Fri, 07 Jun 2013 10:33:59 GMT

Try this for Current Quarter

Ceil(Month(Today())/3)