Hi Anitha,
Follow below steps:
1. Create a calculated field to find the total avg for subcategory using Fixed LOD.
![](https://www.edureka.co/community/?qa=blob&qa_blobid=14612866953232552871)
2. Create another calculated field to create comparison using Exclude LOD.
![](https://www.edureka.co/community/?qa=blob&qa_blobid=13946343758537637040)
3. Now drop the above field and avg(sales) in the sheet.
![](https://www.edureka.co/community/?qa=blob&qa_blobid=11068932180678516458)
4. Drop avg(sales) in to label and below Chart would be shown. The image shows category sales and difference with respect to total average.
( Green bar shows required comparison using exclude lod and red shows avg for each subcategory )
![](https://www.edureka.co/community/?qa=blob&qa_blobid=1551261106017090949)
5. To show more difference i have also added a dual axis beside to show the comparison. ( Orange show the total avg and blue shows avg for each subcategory )
![](https://www.edureka.co/community/?qa=blob&qa_blobid=16234572080012958752)
Hope this helps you.