partial sum/total sum in a graph?

[Avisto.sbu]

Hello

I don't find any way to get an axe in a chart where (partial sum/total sum) with the axe x is a category

the total sum is always filtered by category whatever option I change

is it possible to do such a thing with report studio?

or I should pre calculate everything in a datamart to make sure report studio will maybe be able to display it?

thanks in advance

[MFGF]

Hello

I don't find any way to get an axe in a chart where (partial sum/total sum) with the axe x is a category

the total sum is always filtered by category whatever option I change

is it possible to do such a thing with report studio?

or I should pre calculate everything in a datamart to make sure report studio will maybe be able to display it?

thanks in advance

Yikes! An axe?



In a chart???? Sounds like a recipe for a broken screen! ;)

Sorry - just my feeble idea of humour!

Can you explain in a little more detail what you need? I'm struggling to understand what you are describing. Are you using a dimensional or relational package? Is "(partial sum/total sum)" a calculation?

Cheers!

MF.

[Avisto.sbu]

in fact I mean (axis not axe)

it is a relational package I just want to compute a market share
so it is  (sum of values of turnover filtred by category) / (total sum of turnovers not filtered by category)

I only get the value of sum filtred

it seems that it isn't possible to get the total value (total sums of turnovers) when in the query there is a category

Im not sure to  be clear so I try to find an example:

if we have a set of numbers {5, 6, 7 , 8, 9}  if we suppose 5 and 6 in the same category and  7,8,9 in the same category
I want cognos to compute the total 5+6+7+8+9 =35
I want cognos to return (5+6)/35, (7+8+9)/35

I hope it is more clear

[MFGF]

in fact I mean (axis not axe)

it is a relational package I just want to compute a market share
so it is  (sum of values of turnover filtred by category) / (total sum of turnovers not filtered by category)

I only get the value of sum filtred

it seems that it isn't possible to get the total value (total sums of turnovers) when in the query there is a category

Im not sure to  be clear so I try to find an example:

if we have a set of numbers {5, 6, 7 , 8, 9}  if we suppose 5 and 6 in the same category and  7,8,9 in the same category
I want cognos to compute the total 5+6+7+8+9 =35
I want cognos to return (5+6)/35, (7+8+9)/35

I hope it is more clear

Thanks - that's much clearer. You need to keep things simple for a senile old muppet like me :)

You could perhaps do this with a measure calculation like so:

total([turnover] for [category]) / total([turnover] for report)

Cheers!

MF.

[Avisto.sbu]

thanks very much