5 Replies Latest reply on Mar 1, 2016 4:45 AM by Shinichiro Murakami

Setting up a table to show time series and KPIs in same table

Hi All,

I am trying to setup a table that includes both time series data and KPIs. An example of what I am trying to achieve is shown below.

Any help or direction would be highly appreciated.

Thank you,

Andreas

• 1. Re: Setting up a table to show time series and KPIs in same table

It's quite difficult to understand your request with given info.

Could you attach this excel workbook with expected formula?

Thanks,

Shin

• 2. Re: Setting up a table to show time series and KPIs in same table

Hi Shin,

What I am trying to do is to show forecasted revenue by month for a specific product and then also show certain KPIs related to the product as well. In the example, I have shown revenue for each product by month and then shown how much of the revenue has a probability above 90, between 70 and 89 and less than 70.

• 3. Re: Setting up a table to show time series and KPIs in same table

Here you go.

[>90]

sum(if [Probability] >=90 then [Revenue] end)

[70 <= X <90]

sum(if [Probability] >=70 and [Probability] <90 then [Revenue] end)

[<70]

sum(if [Probability] <70 then [Revenue] end)

The reason the number on [70 <= X <90] is different is you formula misses 89<x<90

Thanks

Shin

9.0 attached.

1 of 1 people found this helpful