
1. Re: Setting up a table to show time series and KPIs in same table
Shinichiro Murakami Feb 25, 2016 10:17 PM (in response to Andreas Gergan)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
Andreas Gergan Feb 25, 2016 11:38 PM (in response to Shinichiro Murakami)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.

Book3.xlsx 12.4 KB


3. Re: Setting up a table to show time series and KPIs in same table
Shinichiro Murakami Feb 26, 2016 3:49 AM (in response to Andreas Gergan)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.

probability_9.0.twbx 16.9 KB


4. Re: Setting up a table to show time series and KPIs in same table
Andreas Gergan Mar 1, 2016 12:49 AM (in response to Shinichiro Murakami)Thanks Shin....very helpful!

5. Re: Setting up a table to show time series and KPIs in same table
Shinichiro Murakami Mar 1, 2016 4:45 AM (in response to Andreas Gergan)You are very welcome.
Enjoy!
Shin