Over (partition by ) query in Cognos Report Studio

If we need cognos to generate analytical function over(partiontion by):

Type	Expression	Cognos query generated
Over() – without partition	total([Planning & Execution].[Shipment].[Shipment ID] for  report)	Fig1
Over (partition by column1,column2,..)	total([Planning & Execution].[Shipment].[Shipment ID] for [Shipment Distance UOM], [Shipment Created Source],[Shipment Last Updated Source])	Fig2

Fig1

Fig2

Note: Set query Auto Group & Summarize option to No