SAC - show number of orders for Top 10 revenue customers

[axel_]

Hi Folks,

I got a chart Top 10 customers by revenue.

Can I apply this customer ranking to another chart (as filter) somehow? E.g. a chart showing number of orders for the top 10 revenue customers?

When I look at the ranking options auf the number of orders chart I see only the measures included in this chart but not "other" measures of the underlying model. 

Thanks in advance for all replies!

Best regards
Axel

PS: I am using a BW Live model if it matters ... and yes I could build in BW a pre-query filter variable etc. but I was wondering if SAC could handle it somehow as for me it is a common requirement (if I would be biz and not IT)

[N1kh1l]

@axel_ 

Just wondering if the linked analysis is on between the 2 widgets and the first is ranked to show 10 customers, this customer filter should be filtering the second order detail widget.

Nikhil

[axel_]

Hello Nikhil, yes linked analysis is switch on between ranked widget and the order detail widget. But the ranking is not impacting the order detail widget .... there more than 10 customers are shown. Best regards Axel

[N1kh1l]

Axel, In that case you could read the customer from table 1 using script and pass it as filter to table 2 using setdimensionfilter