Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Is there anyway to show the Fruit on 01/01/2018 and 02/01/2018?
As John has different fruit on same date, hence the pivot table won't show the value.
I would like to see 'Apple & Banana' on 01/01/2018 and 'Banana & Orange' on 02/01/2018.
Is there anyway to do it?
Please find attached my qvf and excel files.
and also my screenshot for your references.
Use this expression
Concat(DISTINCT Fruit, '/')