Hi! You might find Part 9.1 in this playlist useful th-cam.com/play/PLNIs-AWhQzcmEFHyxCRwA_gb29WOz5SJU.html&feature=shared When you have nested groups you can use the scope parameter of aggregate functions to control which level you're working with. I hope it helps!
Hi! You can't change the existing table into a chart but you can add a calculated series to a chart using the same type of expression shown in this video. I hope it helps!
Excellent! Thank you!!!
You're welcome, thanks for watching!
thank you! very good.
You're welcome, thanks for watching!
you're great man!
Thanks Roger, you're great too!
Thanks
You're welcome, thanks for watching!
Very helpful, thank you
You're very welcome, thanks for watching!
I have two columns group ,How set sum total for first column group only
Hi! You might find Part 9.1 in this playlist useful th-cam.com/play/PLNIs-AWhQzcmEFHyxCRwA_gb29WOz5SJU.html&feature=shared
When you have nested groups you can use the scope parameter of aggregate functions to control which level you're working with.
I hope it helps!
What if you have Row Groups and Column Group. How to calculate then the % ?
Hi Joe! Check out the next video in this series, Part 9.3 which shows you how to do this. I hope it helps!
Hai, i just wanna ask..
can i create a chart from the data table (include the percentage or other expresion we create)?
thank you
Hi! You can't change the existing table into a chart but you can add a calculated series to a chart using the same type of expression shown in this video. I hope it helps!
Surprisingly, its not working for me