Dynamic report by project number

[Tobias_Jonsson]

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?

[Tobias_Jonsson]

Thank you, much appreciated.

[Idrissshatila]

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