Hi,
I have created a pivot table (PT) with slicers attached and then a rank table using data from the PT.
To find the return ive used a LARGE formula and that works fine,
To find the 1X2 column header i've used a INDEX & SUMPRODUCT with column*column formula
To find the Odds row header i've used the same as above but with the row*row formula
The problem arises when i have identical ( see below ) values the INDEX & SUMPRODUCT formulas do not return the relevant values
Can this be resolved using the formula already in place? or will i need to add a helper table to resolve, bear in mind this data changes when the slicer option is changed
Many Thanks
I have created a pivot table (PT) with slicers attached and then a rank table using data from the PT.
To find the return ive used a LARGE formula and that works fine,
To find the 1X2 column header i've used a INDEX & SUMPRODUCT with column*column formula
To find the Odds row header i've used the same as above but with the row*row formula
The problem arises when i have identical ( see below ) values the INDEX & SUMPRODUCT formulas do not return the relevant values
Can this be resolved using the formula already in place? or will i need to add a helper table to resolve, bear in mind this data changes when the slicer option is changed
Many Thanks