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:
| Partner | Client | Opportunity Value | Total Sales with Partner | Total Sales History | Total Share |
| 5849 | DQATP OFYXUDVUOL ZRGRKXWMNKV / Hibyras | $31.485,00 | $749,65 | $749,65 | 100,00% |
| 52747 | JDM XHZUGEAS LYY / Gvqlcxk | $5.048,00 | $3.805,71 | $5.281,13 | 72,06% |
| 172640 | BJNIT PWG / Kfqsrxr | $13.188,00 | $2.163,48 | $2.163,48 | 100,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!
