Hoping you guys could help me with something I've been stuck on for awhile.
My company wants to view Sales in a pivot chart in a pivot chart where it shows the brand and then the sales for each month of the quarter then the sales for the quarter, then the sales for each month then a column with the sales for the quarter etc.
Brand Jan-2017 Feb-2017 Mar-2017 Q1-2017 Apr-2017
ABC Sales a Sales b Sales c Sales(a+b+c) Sales d
ZYX Sales a Sales b Sales c Sales(a+b+c) Sales d
I have fields for MonthYear, but I don't know how to get the quarter in there especially in the order I need it.
Ideally I could just use a formula in the pivot object itself and not have to add dimension values into the script as it would require altering many other objects.