How to exclude rows where the totals sum to zero

[paul_ripley]

Hello

I am struggling to exclude rown in a table where the total sums to zero.

This is an example of the load statement

LOAD
Autonumber(%Key_Entity) as %Key_Entity,
Autonumber(%Key_PL) as %Key_PL,
Autonumber(%Key_BS) as %Key_BS,
Autonumber(%Key_Groupcoa) as %Key_Groupcoa,
pl,
btop,
period,
bussline,
voucher_type,
voucher_no,
text,
sequence_no,
DataSource,
'Agresso' as DataTable,
currency,
cur_amount,
   GBP

and this is an example of the table and the set analysis.  I am just wondering id there is a way to exclude the zero numbers

sum({$<period = {">=$(vStartPeriod_CY)<=$(vEndPeriod_CY)"}, pl = {N01,N02,N03,N04,N06,R01}, groupcoa = {">5999"}>}GBP)

Many thanks

[sunny_talwar]

Have you tried to check 'Suppress Zero Values' on the presentation tab?

[paul_ripley]

Yes I have. There are values in some of the lines but they sum to zero.  I think QV shows the lines because there is data in them it just so happens that it sums to zero

[vishsaggi]

Can you share us a sample app you are working on by scrambling your data?

[paul_ripley]

Sorry I don't know how to scramble the data

[sunny_talwar]

Check this link:

Preparing examples for Upload - Reduction and Data Scrambling

[bgerchikov]

Hi Paul,

Try to use calculated dimension something like that:

=IF(AGGR(sum({$<period = {">=$(vStartPeriod_CY)<=$(vEndPeriod_CY)"}, pl = {N01,N02,N03,N04,N06,R01}, groupcoa = {">5999"}>}GBP) , <List chart dimensions here>) <> 0, <Some of your Deminsions>)

Hope it will help.