Hi,
I am using Cognos Report Studio 8.4.1 to create a List for a Pie chart.
There are 4 drivers for Sales, but the 4 drivers are defined as Fact (Measure) items in the Relational Package.
For example, I can get 2014 YTD Sales info like:
[YTD] ...... [Sales] ...... [Sales - Driver A] ...... [Sales - Driver B] ...... [Sales - Driver C] ...... [Sales - Driver D]
2014 2,137,110 24,999 5,421 14,608 2,092,082
Here:
Sales = [Sales - Driver A] + [Sales - Driver B] + [Sales - Driver C] + [Sales - Driver D];
That is: 2,137,110 = 24,999 + 5,421 + 14,608 + 2,092,082
Now I want to create a List for building a Pie chart as follows
[Year] ...... [Sales Driver] ...... [Sales]
2014 ...... [Driver A] ....... 24,999
2014 ...... [Driver B] ....... 5,421
2014 ...... [Driver C] ....... 14,608
2014 ...... [Driver D] ....... 2,092,082
How can I transform Fact (Measure) items into Level items? :o
Can I create a new Data item only for the above 4 Driver names? If I can, how?
Thank you in advance.