i have used sample superstore data for the below example.
i am trying to calculate category and sub-category wise sale ratio using both Dimensions as filters.
created below calculated Fields
please find the attached workbook.
if the above is not the solution you are looking after, please provide some sample workbook.
Evan.twbx 1.2 MB