simply write the calculation as below
then create hierarchy for calculation field then you'll get the correct values.Put Calculation field in filter exclude "Null" .
Please mark my answer helpful if it's satisfied your question.
Find the attached workbook.
group data.twbx 22.8 KB
Follow the below process to achieve
1) Create Group (Foods,Fruits)
2) Group = Product category
3) filter fales
Find the attached workbook 10.1.4.
Please don’t forget to mark Helpful and CORRECT if it solves your problem.
Book3.twbx 15.6 KB
Thank you for your answer.
Your way given me is really usefull for me, then I can solve my problem with that.
Thank you again.