2024 Feb 28 5:03 PM - edited 2024 Feb 28 5:04 PM
In smart table I want to show both totals and subtotals for hours column. I have created smart table with tableType = "AnalyticalTable" and in the backend we have created sap:semantics="aggregate" for EntitySet and sap:aggregation-role="measure" for hours column and sap:aggregation-role="dimension" for other properties for grouping. I tried using summed = true for Analytical column but not able to show totals. Also, I have tried Total/TotalBy annotations. But they also didn't work.
<Annotations Target="Metadata.Cats_Da/">
<Annotation Term="UI.PresentationVariant">
<Record Type="UI.PresentationVariantType">
<PropertyValue Property="Total">
<Collection>
<PropertyPath>Hours</PropertyPath>
</Collection>
</PropertyValue>
</Record>
</Annotation>
</Annotations>
Could anybody please suggest If I miss something.
Thanks,
Teja.
Request clarification before answering.
Any suggestion please.
In Header item menu 'Total' is showing but not able to aggregate. It's displaying as below. We would like to perform totals and subtotals.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
76 | |
21 | |
8 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.