Doubt regarding drill down

[AishwariyaV]

Hi,
I'm having category sales and product sales as separate columns in a table.
I projected month on X-axis and category sales on Y-axis,when I drill down I want product sales and on X-axis I want the month only.Is it possible??How to sort it out??

[PattemManohar]

@AishwariyaV  Is that mean you have two sales value fields in a single table one for products and other for categories. Please try creating a hierarchy for Categories -> Products and then use this hierarchy in the X-axis and then use the Product Sales in Y-axis, logically the sumup of all the products sales to particular category sales.... 

Any sample test data is always helpful to suggest an accurate solution.

[AishwariyaV]

Thank you for your reply.
Now, consider a line chart.
I need month in axis field.
Category and product sales in value field.
So when I select a particular category and drill down, my line chart has to show sales of products under selected category by month.