Hi,
I used RunningValue function within a table and returned the following
result. I have two questions.
1) How can I remove (not just hide but remove) the first row that
contains "0"?
2) How can I set values beyond Month 3 to blank fields instead of all
of these same "$87,736,926"? This is important because I also need to
create a line chart that contains these two value series and I want the
2006 YTD Sales line to stop at the current point (Month 3 in this case)
and not display any values beyond Month3.
Month 2006 YTD Sales 2005 YTD Sales
0 0
1 $34,934,297 $31,324,975
2 $67,138,492 $66,663,663
3 $87,736,926 $102,636,271
4 $87,736,926 $135,353,722
5 $87,736,926 $170,478,711
6 $87,736,926 $213,173,715
7 $87,736,926 $247,820,997
8 $87,736,926 $285,560,660
9 $87,736,926 $323,379,168
10 $87,736,926 $357,457,266
11 $87,736,926 $395,755,855
12 $87,736,926 $446,351,252
Here is the RunningValue formula I used.
=RunningValue(Fields!Month_Sales.Value, Sum, Nothing)
Any help is much appreciated.
Thanks,
KeithHi,
Get all these things trimmed using your query itself, since these things are
limited in reporting server. anyways.
1. Supressing 0.00 you can use filters.
2. check "Hide Duplicate"
Amarnath
"Keith" wrote:
> Hi,
> I used RunningValue function within a table and returned the following
> result. I have two questions.
> 1) How can I remove (not just hide but remove) the first row that
> contains "0"?
> 2) How can I set values beyond Month 3 to blank fields instead of all
> of these same "$87,736,926"? This is important because I also need to
> create a line chart that contains these two value series and I want the
> 2006 YTD Sales line to stop at the current point (Month 3 in this case)
> and not display any values beyond Month3.
> Month 2006 YTD Sales 2005 YTD Sales
> 0 0
> 1 $34,934,297 $31,324,975
> 2 $67,138,492 $66,663,663
> 3 $87,736,926 $102,636,271
> 4 $87,736,926 $135,353,722
> 5 $87,736,926 $170,478,711
> 6 $87,736,926 $213,173,715
> 7 $87,736,926 $247,820,997
> 8 $87,736,926 $285,560,660
> 9 $87,736,926 $323,379,168
> 10 $87,736,926 $357,457,266
> 11 $87,736,926 $395,755,855
> 12 $87,736,926 $446,351,252
> Here is the RunningValue formula I used.
> =RunningValue(Fields!Month_Sales.Value, Sum, Nothing)
> Any help is much appreciated.
> Thanks,
> Keith
>|||Thanks for your reply, Amarnath!
I tried "Hide Duplicate" and it did work within a table. Do you know
how to apply this to a line chart? Let the line stop at the Month 3 and
not display a straight line beyond Month 3 point.
I also tried to use filter to remove the row with "0". But it always
gave me the following error message.
"...The processing of filter expression for the table can not be
performed. The comparison failed. Please check the data type returned
by filter expression."
Any idea?
Thanks,
Keith
No comments:
Post a Comment