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
Quote from: Avisto.sbu on 23 Apr 2014 10:53:14 AM
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?
(http://survivalblogger.com/wp-content/uploads/2014/02/cold-steel-how.jpg)
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.
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
Quote from: Avisto.sbu on 23 Apr 2014 11:34:42 AM
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.
thanks very much