Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Filter and sort in pivot table

Hi,

Please see the attached sample file.

I'm desperately trying to achieve the following:

  • Filter the list of Partners/Clients by Total Share based on the input table on the right (see Min Share and Max Share) but I don't want the Total Share value to change. For example, at the moment when I manage to get down to the 37095/JDM combination I get Total Share of 100% rather than 0.73% - it looks like the Total Sales History is not correct here (this should always show the total Sales for the Client regardless of the Partner). Just to be clearer, if I select Min Share 70% and Max Share 100% I'd like to see the below:
PartnerClientOpportunity ValueTotal Sales with PartnerTotal Sales HistoryTotal Share
5849DQATP OFYXUDVUOL ZRGRKXWMNKV / Hibyras$31.485,00$749,65$749,65100,00%
52747JDM XHZUGEAS  LYY / Gvqlcxk$5.048,00$3.805,71$5.281,1372,06%
172640BJNIT PWG / Kfqsrxr$13.188,00$2.163,48$2.163,48100,00%

  • The Sort by variable that I'm using to change the sorting of the table seems to work but I was wondering if there is a way to add the Ascending/Descending bit directly in the variable expression without opening the Properties.

The Opportunity filters work fine.

Thanks everyone for your help!

1 Reply
Not applicable
Author

Ideas anyone?