Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Total for value
LatifPatel
Hi all,<br />
I have one problem with total.<br />
I want Total sum when spendtype = 'MAINTENANCE' AND liabcategory = '<$1000'<br />
<br />
for thiz wht i do ,wht i need use ant agreecaiton data or any script plz infrom me..<br />
sum[liability] for facility where spendtype = 'MAINTENANCE' AND liabcategory = '<$1000'<br />
<br />
Thanks <br />
LAtif M PAtel<br />
<a class='bbc_url' href='
http://www.birt-exchange.org/org/forum/public/style_emoticons/'>http://www.birt-exchange.org/org/forum/public/style_emoticons/</a><#EMO_DIR#>/confused.gif
Find more posts tagged with
Comments
thuston
Use an Aggregate control (or binding).
The Aggregate builder has a filter expression. Filter for the ones you want to keep.
So your Agg expression is: [liability]
And Filter is: [spendtype] == 'MAINTENANCE' AND [liabcategory] == '<$1000'