Please find the attached .twbx file. I solved only 2 of the questions you posted. I hope this is what you are looking for. The other two questions are not very clear for me.
exampledata.twbx 2.8 MB
1 of 1 people found this helpful
Here is a training video on how to do the top x rank - Filtering for Top Across Panes
What I am thinking you are after is this - but then you want to kind of 'undo' this rank and display the data (against this rank) but with the original partitionless view - to do this simply add in the field again and hide the ranked field so that you can only see the second field.
I'd do a mockup but I'm about to walk out the door for the day - I'll check if you didn't understand this tomorrow when I get back in and do a mockup if you need me to.
Thank you, Kary. This is really similar to what I was looking for and got me going. I have used companies the same way how you used Product and hid the column so it doesn't disturb the understanding.
I think the reason why the last few questions weren't clear is the difference in the view in your workbook and my imagination
I am re-attaching your workbook with some changes based on the view I am trying to achieve and a screenshot of what I am after:
As you can see, Region opens up to show Country level as well and I hid all other companies but 'Company D' and then I hid the whole Company column from the view.
The questions are the 4 columns.
Thank you for your help,
exampledata (1).twbx 2.8 MB