May 30, 2016 at 11:37 pm
I having problem while showing Total Amount. Can some one help how can I exclude negative values in total.
I having data as below.
Prod Cat --Product -- Year -- Total
-------- | -------- ----- -----
Cat1 -- Prod1 -- 2014 -- 100
Cat1 -- Prod1 -- 2015 -- -50
Cat1 -- Prod1 -- 2016 -- 150
I want my report to be grouped by Prod Cat, Product. Also want negative total values are not consider as part of column total.
If Total is Negative I am hiding that row not to show. But I am seeing that amount is added part of column total.
How can I skip that. I am expecting report as this.
Prod Cat -- Product -- Year -- Total
-------- -------- ----- -----
Cat1 -- Prod1 -- 2014 -- 100
------- Prod1 -- 2016 -- 150
-------------------------------------
Total: 250
May 31, 2016 at 2:37 am
Your best option, if you don't want the data to be shown at all, is using a filter on your tablix.
Open the Tablix properties window, and then select the Filters pane. Click Add, select your field in the Expression field, Integer/float (depending on your data) in the drop down, >= for your operator, and 0 in your value. Click Ok.
If you're unsure, see the attachment below.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 31, 2016 at 11:42 am
Thanks Thom for your help. I am good now.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply