Straight Chart Problems

[anuradhaa]

Hi,

I have a problem and i couldn't find a solution for this. pls help me to solve it.

I have create a Straight Chart, and there i select the BEST TOTAL COST for all destinations.  (destination have multiple values and i select the best one)

Total Cost = Freight Cost + Product Price.

In the chart i have display Freight cost and Product Cost associated with best Total COST.

So when i have multiple values for BEST TOTAL COST , the chart shows '-' in Freight , Product Cost.

But i want to display all available results for that minimum BEST TOTAL COST.

I have attached a xcl file also.

This is the expression i used in the Chart

=min({<OWNER_TO_LOC_FLAG={'Y'}>}TOTAL_COST)

=FirstSortedValue({<OWNER_TO_LOC_FLAG={'Y'}>}ORIGIN,TOTAL_COST)

and i use DESTINATION as Demenssion

[MayilVahanan]

Hi

Try like this

= Aggr(min({<OWNER_TO_LOC_FLAG={'Y'}>}TOTAL_COST), [Best SUP A Origin],DESTINATION)

or

can you provide a sample file?

Hope that helps

[anuradhaa]

Hi pls chk attached QVW for more detail. Here you can see the Origns are missing.

[anuradhaa]

See attached QVW