— The Forums are now read-only —
— All new activity now takes place here: —
I'd like to show Quarters as columns rather than dates in a pivot table.
But when I drag the date to the Columns area of the Pivot Table, I get every single date listed (with the time as well) like this:
I'd like to have the dates combined into only one column for each Quarter. Is this possible?
Hi Kermit,
Yes, this is possible. There is actually a great example in the SalesDemo database that illustrates this.
Basically, for a column that is a date, you can set the Round to property to Quarters and it will automatically set the Format property to "yyyy Q" like this:
Which produces a display of one column for each quarter like this:
Acumatica Version 6.10.0472 used when composing this response
Brilliant!
I can see that example in the SalesDemo database. Looks like it's the Sales by Product by Quarter pivot table on the Invoiced Items generic inquiry.
By using this website, you agree to our Terms of Use (click here)
