Hello,
I have to create a fully prompted report that allows the user to do the following:
List the (Top 10 departments in sales) or (show the departments in the Top 25% of sales) or (Bottom 10) or (Bottom 25%) for a chosen Store, for this week.
Do I have to build separate metrics for Rank Sales, Rank Sales %, etc, and break by Store, have the user answer a prompt with all of these metrics in it, and also answer a prompt with Top 10, or Top 25%? I think that I may be confusing myself with this.
Is this simpler than I am making it out to be?
Thanks,
bitt
I have to create a fully prompted report that allows the user to do the following:
List the (Top 10 departments in sales) or (show the departments in the Top 25% of sales) or (Bottom 10) or (Bottom 25%) for a chosen Store, for this week.
Do I have to build separate metrics for Rank Sales, Rank Sales %, etc, and break by Store, have the user answer a prompt with all of these metrics in it, and also answer a prompt with Top 10, or Top 25%? I think that I may be confusing myself with this.
Is this simpler than I am making it out to be?
Thanks,
bitt