Thanks Alex, glad you found it useful! As for the comments - channel members in the Chick tier get early access to new videos that we release www.youtube.com/@WiseOwlTutorials/join We release these early-access videos to everyone as we produce new content. I hope that helps!
Thanks for the video. Is it possible to create two matrixes only with the dateset "Films", the first one only showing data for ReleaseYear "2010" and the second one only showing data for ReleaseYear "2011"? Thank you very much.
Hi Yuri! Yes, you can create as many report items as you like using the same dataset. You can apply filters to each matrix to control the data that each one displays. We have videos which cover how to apply filters to both datasets and report items which you can find in this playlist (part 5.5 shows how to filter a table which works in the same way for a matrix) ua-cam.com/play/PLNIs-AWhQzcmEFHyxCRwA_gb29WOz5SJU.html I hope it helps!
Hi WiseOwlTutorials. I want to add a new row to calculate the TotalSum of (ReportItems!RunTimeMinutes) for each colum. I used Sum(ReportItems!RunTimeMinutes), but it is not work. Is there another way? Thank you very much.
Hi Yuri! It looks like you're missing the .Value property - ReportItems!RunTimeMinutes.Value You may find it easier to use the Fields collection instead of ReportItems. I hope that helps!
@@WiseOwlTutorials Thanks for your answer. At minute mark 12:05 of your video, I want to calculate the total percentage of each column for the parent group, like 64.71% +35.39% for colum PG or 52.78%+25.23%+21.99% for column 18. The percentages shown are coming from an expression, so there is no Fields collection to calculate this. How can I calculate the sum for this in a new row? Many thanks for your support again.
Great video, takes a while to digest, by the way why would a video from two weeks ago have comments from a year ago
Thanks Alex, glad you found it useful!
As for the comments - channel members in the Chick tier get early access to new videos that we release www.youtube.com/@WiseOwlTutorials/join
We release these early-access videos to everyone as we produce new content.
I hope that helps!
4+2-7*10/50= ?
How to solve this in exel ?
Thanks for the video. Is it possible to create two matrixes only with the dateset "Films", the first one only showing data for ReleaseYear "2010" and the second one only showing data for ReleaseYear "2011"? Thank you very much.
Hi Yuri! Yes, you can create as many report items as you like using the same dataset. You can apply filters to each matrix to control the data that each one displays. We have videos which cover how to apply filters to both datasets and report items which you can find in this playlist (part 5.5 shows how to filter a table which works in the same way for a matrix) ua-cam.com/play/PLNIs-AWhQzcmEFHyxCRwA_gb29WOz5SJU.html
I hope it helps!
3:57 4:00 4:01
Hi WiseOwlTutorials. I want to add a new row to calculate the TotalSum of (ReportItems!RunTimeMinutes) for each colum. I used Sum(ReportItems!RunTimeMinutes), but it is not work. Is there another way? Thank you very much.
Hi Yuri! It looks like you're missing the .Value property - ReportItems!RunTimeMinutes.Value
You may find it easier to use the Fields collection instead of ReportItems.
I hope that helps!
@@WiseOwlTutorials Thanks for your answer. At minute mark 12:05 of your video, I want to calculate the total percentage of each column for the parent group, like 64.71% +35.39% for colum PG or 52.78%+25.23%+21.99% for column 18. The percentages shown are coming from an expression, so there is no Fields collection to calculate this. How can I calculate the sum for this in a new row? Many thanks for your support again.