I created a pivot chart that contains Job and Revenue amount. The type of Revenue is determined by the type column.
There are two types 'A' or 'B'. This determines Actuals or Budget.
There is a Job column as well. Containing 105 and 106. I attached a sample workbook.
Job Dept Name Revenue
105 105 Budget 1912
105 Actual 519
106 106 Budget 1100
106 Actual 350
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...