Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have date filed in table. In this table Oct-2017, Oct-2018, Nov-2018 data only available. i am created master calendar on that date filed. then i am taking any field like month and year etc. I am not getting null values. All months showing equal data (Sum of all months data in each month).
Ex: I have month sales like
Oct-2017 -- 150
Oct-2018 -- 200
Nov-2018-- 250
Output:
Jan- 600
Feb- 600
Mar-600
Apr-600
-
-
-
Dec-600:
If iam using directly Month function (Not creating master calendar), i am getting correct output.
Can you share the script and sample data to check?