Author Topic: Pie chart with 4 calulated data items as series  (Read 81 times)

Offline cognos05

  • Statesman
  • ******
  • Join Date: Apr 2014
  • Posts: 690
  • Forum Citizenship: +1/-1
Pie chart with 4 calulated data items as series
« on: 31 Jul 2020 10:12:38 pm »
Hi ,

I need to show a pie chart with four segments , each four being its one calculation measure .

I am using fm model as source and these are my 4 data items .

1)
total(case when ([AME Billings].[Promo].[Promo Code] = '' OR  [AME Billings].[Promo].[Non Promo Exclusion Flag] = 'X')
and [AME Billings].[Billings].[Sales Type Category] = 'Direct Sales'
then [AME Billings].[Billings].[Revenue At List Doc Currency] - [AME Billings].[Billings].[H1 Full Revenue Doc Currency] else 0 end for [Bill-to Customer Number])

2)
total(case when ([AME Billings].[Promo].[Promo Code] = '' OR  [AME Billings].[Promo].[Non Promo Exclusion Flag] = 'X')
and [AME Billings].[Billings].[Sales Type Category] = 'Consignment Sales'
then [AME Billings].[Billings].[Revenue At List Doc Currency] - [AME Billings].[Billings].[H1 Full Revenue Doc Currency] else 0 end for [Bill-to Customer Number])

3)
total(case when [AME Billings].[Promo].[Promo Code] <> '' AND  [AME Billings].[Promo].[Non Promo Exclusion Flag] = ''  then [AME Billings].[Billings].[Revenue At List Doc Currency] - [AME Billings].[Billings].[H1 Full Revenue Doc Currency] else 0 end for [Bill-to Customer Number])

4)
coalesce([AME Billings].[Bill-to Customer].[R12 Rebate Amount],0)

Each measures are already embedded int he data items .

How can i  show this 4 data items in 1 pie chart .

Any suggestions is appreciated.

Thanks,



 



       
Twittear