Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have field billing
billing
accounts
payment
tenders
dues section
fines section
I am using billing field as dimenstion, now i dont want to display tenders and dues section columns in my chart?
Can anyone please help me ASAP.
Thanks,
Durga
Load * Inline [
billing,payment
tenders,100
dues section,200
aaa,50
bbb,60 ];
In Chart,
Calculated dimension: =Aggr(Only({<billing -= {'tenders', 'dues section'}>} billing), billing)
Expr: sum(payment)
Check "Suppress When Value is NUll" in chart
hi,
In your dimension> edit the dimension
if( Billing = 'tenders' or Billing = 'dues section' , null(),billing)
Check the option for hide null values.
HTH
sushil
Hi Durga,
Just you remove those fields from your chart(dimensions)
Priyantha.
Sushil not getting any changes to chart after giving condition. i used suppress when values is null also.
Durga
how to remove field in edit script without going to source data.
Durga
Hi
Use this for the calc dimension:
=Aggr(Only({<billing -= {'tenders', 'dues section'}>} billing), billing)
HTH
Jonathan
can you share your sample app ?
In script,
Load * From Table
Where Not (Billing = 'tenders' or Billing = 'dues section');
it showing syntax error under { besided 'tenders. I cross checked, everything i kept fine. but showing error.
It's not syntax error. Red marks are due to minus used in Set analysis
=Aggr(Only({<billing -= {'tenders', 'dues section'}>} billing), billing)