PIVOT Sort doesn't work with addition of column field?
Hi All,
I'm probably missing something simple here. In this example, I can successfully sort by "Return Units" in my pivot until I drop my fiscal year field into the "Columns" area. This blows out the sort and I'm unable to restore it.
What am I missing?
Thanks very much.
Attachment 801807Attachment 801806
Last edited by pmjewett; 10-21-2022 at 05:03 PM. Reason: Appending attachment
read big yellow banner at the top of this site
Excel file attached.Originally Posted by sandy666
read big yellow banner at the top of this site
Thanks!
Last edited by pmjewett; 10-21-2022 at 05:03 PM.
and you want to sort Return Units: smallest to largest or largest to smallest ?
Largest to smallest
smallest is : -13180
largest is : 0 ?
did you think about move Fiscal Year into the filter ?
Last edited by sandy666; 10-21-2022 at 06:08 PM.
Return Units without Fiscal Year in Columns should sort from top (22,764) to 0
With Fiscal Year across the top I'd want the Return Units column to sort from largest returns down to zero for each of the two years...though starting to occur to me that might not be possible this way..
hmmm
Fiscal Year needs to stay where it is so the user can easily compare to the prior year...unless there's another way to do this?
Last edited by pmjewett; 10-21-2022 at 07:03 PM.
It would be helpful if even the first year FY2022 Return Units could at least sort largest descending to 0
this is Pivot with Fiscal Year from raw data sorted by Index
btw. there are negative numbers so 0 is largest(red colour with brackets means: negative)
Last edited by sandy666; 10-21-2022 at 07:11 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks