Benchmarking table

[McLaughlinMatt]

I'm trying to set up a table so that an individual can benchmark themselves against larger aggregations of the same data. The data is hierarchical like this:

Salesperson, Salesgroup, Office, WidgetAsSold, WidgetBsSold,WidgetCsSold

And what I want to end up with is a simple grid like this:

	SalesPersonA Sales	SalesPersonA's SalesGroup Average Sales	SalesPersonA' Office Average Sales	Companywide Average sales
WidgetAsSold	10	8	9	9
WidgetBsSold	15	14	17	16
WidgetCsSold	25	30	28	27

Any suggestions would be very much appreciated

[Brett_Bleess]

Matt, try looking around in the Design Blog area of Community:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

This is the base link, there is a search box there you can use to try to find some posts that may help you come up with a working model here.  I suspect the reason for lack of responses is no info regarding the source data etc. such that folks would be able to tell you what you need to do in the load script to get it into a data model that would allow you to create the chart you want.  The Design Blog area consists of more than 700 posts from our internal experts, and most are how-to related, so that should be helpful, but it may take a bit to find the posts you need to get your solution completed I expect.  Sorry I do not have anything better, if you can provide further details on the source data I think that will likely help get some further responses if you want them, a sample Excel file or text file etc. that mimics things would likely be best.

Regards,
Brett