When you bring 3 at a lower level then it will show at the drill level only. if you want to showcase at the department level then use the exclude lod to exclude three levels in tableau.
BI, Aspire Systems (India) Pvt Ltd
Could you throw more light on how I can implement this? Once I join the datasets using an inner join on deparment, the number of rows goes beyond 1000, where as I have only 150 rows in the dataset which is at department level. So my revenue value which should have been 100M goes up to 2000M. I used LODs to exclude various levels and still get the same value.