This content has been marked as final. Show 2 replies
I need to calculate the count of subcategory for each category (distinct category) and I need to split into the following, as below
Input Sample Data :
And the output should be as below
|Wk||1Cat-1SubCat||1Cat - 2SubCat||1Cat - 3SubCat||1Cat - 4SubCat||1Cat > 4 Subcat|
This is a sample data. I have more weeks and so the data has to be dynamic, when adding new / upcoming weeks data. Kindly let me know, in achieving this. Thanks guys.