Hi All,
I have created a pivot table in order to get the values for each quarter and now I need to calculate a new field based only on the values of Q1 for each period.
e.g.
NewField = (Feb/18) * Q1 for 2018 = 100*123 = 123,000.00
NewField = (Mar/18) * Q1 for 2018 = 1515*123 = 186,345.00
[...]
Any suggestions??
I appreciate the help in advance.