More crosstab customization
I know this is a function of the company Foundant contracts with on the reporting tool, but I would really like to be able to reverse the direction of a crosstab or sort data within a crosstab. We use a crosstab to show awards by organization, by year, from inception to date. In the old reporting tool, they were shown most recent year on the left, oldest on the right and in alphabetical order. Under this reporting tool I cannot re-organize it to be viewed the same way and thus I have to recreate it all in excel.
Mariah Williams
shared this idea
Hi Mariah,
Part of the issue might be browser because the dots needed can be a bit persnickety. But I was able to just adjust a cross top as you which.
First off to sort alphabetically left click on the header organization name. Then to sort in the column headers on the left you will 6 dots if you click and hold on these it will help you drap and drop the columns into the correct order.
Let us know if you don’t see the dots or if the sort does not work for you.
Best
sammie