No subtotals in query

[Former Member]

Hello,

I don't want to have subtotals in query's result; is-it possible ?

Regards,

Thierry

[koleti_madhusudan · Accepted solution]

Hi,

Yes, you can suppress sub totals.

follow the steps given below

1. Suppose in the rows panel you have characteristics Product ID, Customer ID & Cal month...select Product ID object ---go to properties --->select 'Display' tab and set 'Result rows' as 'Alsways display'. For the remaining characteristics which are rows panel set display property as 'Always suppress'

First characteristic in the rows panel should have result rows as 'Always display'

This is the way , we can avoid sub totals

Thanks,

Madhu

[Former Member · Accepted solution]

Thank you very much.

it works fine.

Regards.

[former_member202718]

Hi Thierry,

Yes ,it is possible.

Suppose if you have 4 Chars in the Rows ,make sure that for the last three Chars ,in the properties tick Supress--> Display result.Keep only the first Char as display result.

Now you can see only Totals,if u dont want that then remove that also.

Rgds

SVU123

[former_member182516]

Hi Hussai,

Not sure but give a try...

select the Kf -- goto properties on the right hand side -- select "calculations" tab --> check what is selected for "calculate results as" -- set that to nothing defied and check...

Regards

KP

[Former Member]

Hi,

Supress result rows in the display tab except first characteristic in Rows.so you can see only one result row.

Regards,

Jayapal