Forum Discussion
Dynamic report by project number
Hello, I want to create a report for revenue, COGS and margin by project number. There can be different project numbers for each month and I want the report to automatically include the project numbers, just like a pivot table. How can this be solved?
2 Replies
Hello Tobias_Jonsson ,
If you have the data of all the projects in one table, and you put like a table visual with the project number in row and the revenue, cogs,etc... in the value field, they will automatically show when the data is refreshed.
you may also look into these videos
https://youtu.be/PI52ckgezzA?si=mclHD4lW_A8ExGTJ
https://youtu.be/J4317R5BvsA?si=V9d4Wou1APigeiS3
Thank you, much appreciated.
