Loading ...

QQube Transaction Date Dimension | CLEARIFY

Comments (2)

   
moejurray

The dates of my Purchase Orders only show as MMM, Apr for example. Date and year are impossible to show in reformatting cells or Field Settings in the pivot table.

4/15/2020
 · 
 /5
0 (0votes)
by
   
admin

This is the result of Excel "Grouping" which can be turned off for the column by right clicking and selecting "Ungroup". Excel will automatically create groupings for date columns e.g. year, quarter, month, date whenever you drag a date field into a pivot table. All dates in QQube are formatted as dates.

4/16/2020
 · 
4.44 
 /5
4.44 (1votes)
by