2 of 2 people found this helpful
Please follow below steps
1. Connect your above data in Tableau using Excel or CSV.
2. Your data will look like below
3. Now select all project are like below
4. Right click on grey area and use Pivot Function. Your data will turn into below format.
5.Rename your newly field according to your comfort.
6. Write and formula
Hope this is your requirement.
Nice explanation. Thanks Sandip.
you are very clear and structured. You helped me a lot.
Just a final question: on point number 6, can you please give me a screenshot of the formula you utilized?
Thanks a lot for your support