You may be able to use dimensionality. Dimensionality is designed to return the aggregation level of an expression total. In the example above, Dimensionality() in its own expression would return 1 on the row for Total Bra, 2 on the subtotal rows for each bra type, and 3 for the lowest level bra type/style data. That said, you could write your expression to run different expressions based on their aggregation level like this (using pick to avoid nesting ifs):
Thanks Rocky. This example is a pivot table, with subtotals, and the relative box isn't available for pivot tables. If I do as a straight table, and check relative, then I get just % to the Grand total and not % to Subtotal results, which is what I'm looking for. Any other suggestions?
You may be able to use dimensionality. Dimensionality is designed to return the aggregation level of an expression total. In the example above, Dimensionality() in its own expression would return 1 on the row for Total Bra, 2 on the subtotal rows for each bra type, and 3 for the lowest level bra type/style data. That said, you could write your expression to run different expressions based on their aggregation level like this (using pick to avoid nesting ifs):
