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.