Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I would have an expression in a chart, that can let me know what else custumers buy when they buy a specific product.
I attached for you perusal an excel file with three sheets.
Is it possible to select a Family and view what else, the custumers those buy the selected family , buy.
I hope you can help me.
Thanks
Andrea
So why not just use
=count({<Company = p(), Family= >}[Order N°]) / count(total {<Company = p(), Family= >}[Order N°])
or
=count({<Company = p(), Family= >}[Order N°]) / count(total<Company> {<Company = p(), Family= >}[Order N°])
and format the number on numbers tab as percentage.
2nd Expression works, first one, that I had tried before asking you, doesn't.
Thanks again.
I think this kind of analysis is very interesting, but maybe you know something more usefull.
We want to cut some products, but we don't know the effects that this razionalization should has on our sales.
It could be interesting even a pivot chart? with as dimension family and inside again the families those are bought with the first family. I know.. My reasoning is complex, but I hope I understand me, again!
You can check these samples and see if they match your requirements:
Thank you Stefan,
unfortunately I have the free version and I can not open the example files, nevertheless You was very very kind.
Best regards
Andrea