webi: reference filtered cell value

[Former Member]

Hello,

I'm working with SAP BO WebIntelligence and have a filtered block outputting a value of 30 (filter is reducing total from 590 (restricting to the last 31 days)).

Is it possible to reference the value of this cell (30) in the below text formula?

=If(NumberOfRows([print]) = 0) Then "No print books purchased this month." Else ([print].[Total items]) + " total print books purchased this month."

The cell formula is:

=Sum([print].[Total items])

The output is always the unfiltered result of 590. Is there a way I can get my filtered result of 30 referenced outside of the filtered block?

Thanks for your time and assistance,

Joe

[amitrathi239]

is there any filter applied on the table where total values are coming 30.if yes add those filter in the where clause to get 30.