· **Crosstabs with multiple Row and Column dimensions**

1) **Derive summary on second level (or any**** level****) **__Row dimension__

__Description: __

Calculate the summary value of second-level (or any level) Row dimension using summary function.

__UDDC Expression:__

UDDC Expression for calculating Summary:

summary( rowDimension, ””, Measure ) |

__Example: __

__ __

UDDC Expression for calculating Summary of second level Row (City) Dimension - UDDC_Summary:

summary(City, "", GrossSales ) |

As per the below example,

there are two dimensions kept in the row. They are state (1^{st} ) and city (2^{nd} ).

For the year 2020, the sum of Gross sales of all the cities of Arizona State is ** 5870344.92.** Hence the UDDC_Summary value is

__5870344.92__For the year 2021, the sum of Gross sales of all the cities of Arizona State is ** 10917066.89.** Hence the UDDC_Summary value is

__10917066.89.__2) **Derive summary on second level (or any**** level****) **__Column dimension__

__Description: __

Calculate the summary value of second-level (or any level) Column dimension using summary function.

__UDDC Expression:__

UDDC Expression for calculating Summary:

summary( “”, ColumnDimension, Measure ) |

__Example: __

__ __

UDDC Expression for calculating Summary of second level Column (Quarter) Dimension - UDDC_Summary:

summary(“”, Quarter, GrossSales ) |

As per the below example,

there are two dimensions kept in the row. They are Year (1^{st} ) and Quarter (2^{nd} ).

For the State Arizona , the sum of Gross sales of all the Quarters of Year 2020 is ** 5870344.92.** Hence the UDDC_Summary value is

__5870344.92__For the State Arkansas , the sum of Gross sales of all the Quarters of Year 2020 is ** 17265305.16** Hence the UDDC_Summary value is

__17265305.16__# | Type of Summary | Expression | Example |

1 | Derive summary on second level (or any) Row dimension | Summary( Row dimension “”, Measure ) | Summary( City,“”, Grosssales ) where City is the second row dimension in the crosstab on which the summary will be calculated. Since we are calculating City wise summary here, the column dimension will be empty (“”). The output will be the state wise sum of gross sales of all the cities. |

2 | Derive summary on second level (or any) Column dimension | Summary (“”, Column Dimension,, Measure) | Summary("",Quarter,GrossSales) where Quarter is the second column dimension in the crosstab on which the summary will be calculated. Since we are calculating Quarter wise summary here, the row dimension will be empty (“”). The output will be the year wise sum of gross sales of all the quarters. |

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Feedback sent

We appreciate your effort and will try to fix the article