Constant Values in Pivot Chart

[#1]

Hi,

Could anybody tell me how can i show a constant value in the pivot table expression..

I want to get a Constant value for all rows in the Pivot Table. The value should be maximum of the Unload Qunatity.

Here i am attaching a Image, in this i want to get the value 25182 for all the location AZ..

Thanks

Renjith kumaran

[shree909]

Hi  if ur using the set analysis  use  1 u will get all the values irrespective of selections.

$ will give current selections

sum({1<date= {'04/39/2013'} >}sales)

or else put a sample file  it will be easy to figure it out..

Thanks

[#3]

Shree,

i dont need the data based on date. It will be a bit difficult to publish the file as its a live file of my client. I will try to add a dummy one.

I just need to show the constant value there.

Thanks

Renjith Kumaran

[#4]

Anybody?

Please advice me to find a way..

Thanks

Renjith Kumaran