Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I'm strugling again with creating an expression in a chart.
I have 3 fields called Zone ,Tendu/Stock and Colli.
I want to see by Zone how may % is Tendu and how many % is Stock in a chart.
No clue what so ever on how I can manage this, can someone help me please, I've attached the QVW with the data.
Kind regards,
Monique
see attachment
or from online help
If the word total occurs before the function arguments the calculation will be made over all possible values given the current selections but disregarding the chart dimension variables.
The total qualifier may be followed by a list of one or more field names within angle brackets. These field names should be a subset of the chart dimension variables. In this case the calculation will be made disregarding all chart dimension variables except those listed, i.e. one value will be returned for each combination of field values in the listed dimension fields. Also fields which are not currently a dimension in a chart may be included in the list. This may be useful in the case of group dimensions, where the dimension fields are not fixed. Listing all of the variables in the group causes the function to work when the cycle or drill-down level changes.
sum(Colli) / sum(total<Zone> Colli)
The "total" qualifier makes expression to ignore dimensions of the chart. The total<Zone> tells to ignore dimension except Zone. That is you get sum logically "grouped by" Zone.
See "help" regarding "total' and "all" for more details.
A big thanks to all who helped me, I am so gratefull and also for explaining the solution.
This is really educational.
Monique