I think it would be easiest if you had a separate column for Kellogg brands in each category. Is that possible to implement in your data source?
I am assuming you have more cold cereals than just Kellogg, and that you want to do each manufacturer divided by the total of all product rows in that category.
Take out the roll-up row. That's messing you up.
Add in a column for manufacturer. Then tableau can do each manufacturer divided by the sum of all manufacturers for you.
If I am misunderstanding what you are looking to do, it will help to post a packaged workbook with sample data so we can see what you have and work with a concrete example.
Thanks Naveen and Joe. Thanks for your time.
Changing the data source is bit difficult for me. Because we have around 50k rows....and 25 measures ($).....
I think separating the column is my last option. I have to see....
Here in sample data I have given only category but I have customers and Brand columns also, where user have hard coded formulas in excel and I have to implement this in tableau.
For category, customer and brand I Need to do separate columns......
Any how thanks agian for your valuelable time...:)
If you have the Brand column, it may be possible to sum by brand then divide by the total sum to calculate the ratio you are looking for. Can you post a data extract that shows all columns?
I don't see the sample data anywhere.
You might be able to simulate the extra column with calcs. Seeing the data will help determine that.