In one of my SSAS- cube one attribute(inset_date) which is Date datatype and format is yyyy-mm-dd, when I checked in excel pivots it is not coming in order.
I have changed the order by property from name to key but it is not sorted,
Key -- insert_date(date)
Name -- insert_date(wchar)
Value-- insert_date(date)
Can you please what other properties I have to change to sort the attribute of a dimension?
Asked by Ravi Teja
(1 rep)
Sep 24, 2020, 10:32 AM
Last activity: May 27, 2025, 12:00 AM
Last activity: May 27, 2025, 12:00 AM