SUCCES charts - water fall charts

Post Reply
mrdauduong
Posts: 52
Joined: Mon Sep 26, 2022 11:10 am
OLAP Product: Planning analytics
Version: PA 2.0.74.23
Excel Version: Excel 2016

SUCCES charts - water fall charts

Post by mrdauduong »

hi, 
i have an client who want to do a SUCCESS charts (or waterfall charts). they need to comparer 2 versions and check the reason by various aspect (for exemple, by section, by month)...

is waterfall charts can do this? (everything, i got the sum colum at the end, i can not put 2 colums versions at the same level)

this is the best thing i can do until now :D (last colum is a sum and i can chose only 1 measure for comparer)

thank for your help. 
Attachments
best i can do waterfall charts.png
best i can do waterfall charts.png (41.67 KiB) Viewed 1219 times
cube reporting succes charts.png
cube reporting succes charts.png (133.65 KiB) Viewed 1219 times
ask by client.png
ask by client.png (52.7 KiB) Viewed 1219 times
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: SUCCES charts - water fall charts

Post by Wim Gielis »

Crossposted on the IBM PA forums.
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
mrdauduong
Posts: 52
Joined: Mon Sep 26, 2022 11:10 am
OLAP Product: Planning analytics
Version: PA 2.0.74.23
Excel Version: Excel 2016

Re: SUCCES charts - water fall charts

Post by mrdauduong »

Wim Gielis wrote: Mon Oct 03, 2022 7:18 am Crossposted on the IBM PA forums.
hi Wim Gielis,

new in this forum, what you means when you said "crossposted"? (i posted in IBM PA community this post too while hoping a reponse), is this a problem?

thank for your reponse.
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: SUCCES charts - water fall charts

Post by Wim Gielis »

mrdauduong wrote: Mon Oct 03, 2022 2:25 pm
Wim Gielis wrote: Mon Oct 03, 2022 7:18 am Crossposted on the IBM PA forums.
hi Wim Gielis,

new in this forum, what you means when you said "crossposted"? (i posted in IBM PA community this post too while hoping a reponse), is this a problem?

thank for your reponse.
At the very least, inform both places of the other location.
Do you expect volunteers spend time and effort when somewhere else it is already solved or more information is available ?
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
mrdauduong
Posts: 52
Joined: Mon Sep 26, 2022 11:10 am
OLAP Product: Planning analytics
Version: PA 2.0.74.23
Excel Version: Excel 2016

Re: SUCCES charts - water fall charts

Post by mrdauduong »

Wim Gielis wrote: Mon Oct 03, 2022 3:39 pm
mrdauduong wrote: Mon Oct 03, 2022 2:25 pm
Wim Gielis wrote: Mon Oct 03, 2022 7:18 am Crossposted on the IBM PA forums.
hi Wim Gielis,

new in this forum, what you means when you said "crossposted"? (i posted in IBM PA community this post too while hoping a reponse), is this a problem?

thank for your reponse.
At the very least, inform both places of the other location.
Do you expect volunteers spend time and effort when somewhere else it is already solved or more information is available ?
thank. i will make attention next time.
probleme solved.
problem solved.PNG
problem solved.PNG (82.32 KiB) Viewed 1098 times
Last edited by mrdauduong on Mon Oct 10, 2022 7:51 am, edited 1 time in total.
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: SUCCES charts - water fall charts

Post by Wim Gielis »

mrdauduong wrote: Mon Oct 03, 2022 3:42 pm
Wim Gielis wrote: Mon Oct 03, 2022 3:39 pm
mrdauduong wrote: Mon Oct 03, 2022 2:25 pm
hi Wim Gielis,

new in this forum, what you means when you said "crossposted"? (i posted in IBM PA community this post too while hoping a reponse), is this a problem?

thank for your reponse.
At the very least, inform both places of the other location.
Do you expect volunteers spend time and effort when somewhere else it is already solved or more information is available ?
thank. i will make attention next time.
probleme solved.
Are you serious ? You created 12 topics in the IBM community, most of which are overlapping with the many topics here. None of them will contain a cross-reference. Please don't expect any help from my side.
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
mrdauduong
Posts: 52
Joined: Mon Sep 26, 2022 11:10 am
OLAP Product: Planning analytics
Version: PA 2.0.74.23
Excel Version: Excel 2016

Re: SUCCES charts - water fall charts

Post by mrdauduong »

Hi,

I want to ask a question in both place, and i try to say "it is finised" or "problem solved" when i got the reponse from 1 of community.

What you advise me to do?

Iam new in this forum, just tell me what i need to do and i will follow the rule.

Thank!
Wim Gielis wrote: Sun Oct 09, 2022 6:51 pm
mrdauduong wrote: Mon Oct 03, 2022 3:42 pm
Wim Gielis wrote: Mon Oct 03, 2022 3:39 pm

At the very least, inform both places of the other location.
Do you expect volunteers spend time and effort when somewhere else it is already solved or more information is available ?
thank. i will make attention next time.
probleme solved.
Are you serious ? You created 12 topics in the IBM community, most of which are overlapping with the many topics here. None of them will contain a cross-reference. Please don't expect any help from my side.
mrdauduong
Posts: 52
Joined: Mon Sep 26, 2022 11:10 am
OLAP Product: Planning analytics
Version: PA 2.0.74.23
Excel Version: Excel 2016

Re: SUCCES charts - water fall charts

Post by mrdauduong »

None of them will contain a cross-reference ==> what you means? that means when i post something on IBM community (other side) and i post same thing here, i should post the link of the both place? right?

sorry for my bad english.


If this is what you means, i will do it from now (and correct all my post before) :geek:
mrdauduong
Posts: 52
Joined: Mon Sep 26, 2022 11:10 am
OLAP Product: Planning analytics
Version: PA 2.0.74.23
Excel Version: Excel 2016

Re: SUCCES charts - water fall charts

Post by mrdauduong »

just update all the IBM community cross posted link on all my old post.

thanks !
i will make attention for the next time
Wim Gielis wrote: Sun Oct 09, 2022 6:51 pm
mrdauduong wrote: Mon Oct 03, 2022 3:42 pm
Wim Gielis wrote: Mon Oct 03, 2022 3:39 pm

At the very least, inform both places of the other location.
Do you expect volunteers spend time and effort when somewhere else it is already solved or more information is available ?
thank. i will make attention next time.
probleme solved.
Are you serious ? You created 12 topics in the IBM community, most of which are overlapping with the many topics here. None of them will contain a cross-reference. Please don't expect any help from my side.
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: SUCCES charts - water fall charts

Post by Wim Gielis »

mrdauduong wrote: Mon Oct 10, 2022 7:52 am just update all the IBM community cross posted link on all my old post.

thanks !
i will make attention for the next time
Thanks. Vice versa as well: updating posts here with the link to the IBM posts. We’re you in such a hurry that1 posting in 1 community was not sufficient ?
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
mrdauduong
Posts: 52
Joined: Mon Sep 26, 2022 11:10 am
OLAP Product: Planning analytics
Version: PA 2.0.74.23
Excel Version: Excel 2016

Re: SUCCES charts - water fall charts

Post by mrdauduong »

Wim Gielis wrote: Mon Oct 10, 2022 8:27 am
mrdauduong wrote: Mon Oct 10, 2022 7:52 am just update all the IBM community cross posted link on all my old post.

thanks !
i will make attention for the next time
Thanks. Vice versa as well: updating posts here with the link to the IBM posts. We’re you in such a hurry that1 posting in 1 community was not sufficient ?
Vice versa as well: updating posts here with the link to the IBM posts. => just did for all post on IBM community and TM1 forum.
We’re you in such a hurry that1 posting in 1 community was not sufficient ? ==> for now, i dont know which community is better, so, i post in both community with hope for a reponse. but i will make a choice later for sure.

Most of time, i got a good reponse in here.
But sometime (for ex: for this question) i got a good reponse in IBM community.

thanks for your reponse !
Post Reply