Is this possible?? (Don't know what the subject for this would be)

[#1]

We create models for Manufacturers, we can show them Market share between certain Ingredients etc.

I am trying to create a report that will show only the selected manufacturers' (will probably have to be a variable) market share % and Sales out of a total and display the other manufacturers' in that report as 'Other'. I want to do this purely because i do not want the Manufacturer to see the Other Manufacturer's Market shares.. I guess i would like it to look something like below..

What i find difficult is that a selection cannot be made while viewing this report because the total Market share percentages have to be shown so somehow i have to create a variable that only shows the specific manufacturer without making a selection (sorry for the repetitiveness).

Any Ideas would be much appreciated??

[#2]

Pie Chart can't behave the way you requested. The result however can be reached through script.

See attached example.

[#3]

Thank you for your response.

I've tried applying your script to mine (see below)

MarketTemp:

load Market, BarCode

resident Market;

TransactionalDataTemp:

inner join (MarketTemp)

load Sales, BarCode

resident TransactionalData;

temp:

LOAD sum(Sales) as TotalSales

resident MarketTemp;

let _totalsales = peek('TotalSales');

drop table temp;

TABLE2:

LOAD *, $(_totalsales)-Sales as OthersSales

resident MarketTemp;

drop table MarketTemp;

TABLE3:

LOAD BarCode, Market as Market1, Market as Label, Sales as MarketShare

resident

TABLE2;

LOAD Market as Market1, 'Others' as Label, OthersSales as MarketShare

resident TABLE2;

drop table TABLE2;

I reloaded it, and tried to apply it to Pie chart (see below)

I then looked at the table viewer and saw that there was a syn table, maybe this will also help you see more on how the model works etc. (see below)

I hope this helps, sorry for the hassle.

By the way i'm using 8.5, don't know if it makes a difference.

Thanks

[#4]

That was an example based on provided information. It was to demonstrate a technique. Of course it will not work into a more complicated model.

You have to grasp the idea behind it and implement it in to your application.

[#5]

Yes i know,

you see what i have is a transactions table and a manufacturer reference table joint on a unique product code.. What i did was did a resident load on both those tables and joint them together to form a table i was hoping to act like your 'Load Inline' table, then applied your script from there obviously using different field names etc that related to my set of data.

I will keep playing around with it though..

Thanks