3 Replies Latest reply on Jul 2, 2013 7:28 AM by Jonathan Drummey

    Sort with measure from secondary data

    Thibault Reynier

      Hi everyone !

       

      I would like to sort my data with a measure coming from my secondary data source.

      Is there a way to do it or a work around possibility?

       

      As well, I have created a rank with the INDEX() function, I also would like this rank to adapt on this measure form the secondary data source.

       

      I have attached an example of a workbook like mine.I cannot blend the data with Excel... Do you have a way to sort the client by their average money spent? If not possible, we swap primary and secondary data source but I would like to be able to do the "only relevant values" for the filters.

       

       

      Thank you very much for any help! This is pretty urgent actually...

       

      Best regards,

       

       

       

      Thibault