How to show all the values in Straight Table when selected

[krishna20]

Hi friends

i'm having company dimension in straight table following calculations to that.When i selected a company.Its showing the particular company details only.I need to show all the companies when selection also.How it Overcomes.?Can any one pls help me out.

Regards

Krishna

[krishna20]

Hi Ashok.

Thank you for your reply.But in the document the selected values is not moving to the top.

Regards

Krishna

[krishna20]

Hi Avinash

Please find the attachment..Dashoard Tab.First straight Table..I'm having many expressions..I dnt know where to place the logic.

Regards

Krishna

[krishna20]

Hi Ashok,

Please find the attachment.IDashboard Tab-> First straight table.I have used many expressions.I dnt come to know where to place the logic which u suggested me.Pls Help me out..

Regards

Krishna

[avinashelite]

Hi kalyan,

Please find the screen shot , where u need to give the logic

[avinashelite]

Hi kalyan,

Please find the attachment for solution according to your requirement its populating the Selections at the top.

Please see the script and sorting option in the properties.

regards,

@vi

[krishna20]

Hi Avinash

I did it.But the unselected values result showing as zero.Wat may be the issue?

Regards

Krishna

[avinashelite]

Hi kalyan,

Are you using any variables in the calculation???

Please post the app let me check

[krishna20]

Hi Avinash,

no,.i used like =sum({<COMPANY>}Amount).

for other expressions im using variable vCurrentYear.

pls find the below attachment.Dashboard tab.First table

Regards

Krishna

[avinashelite]

Hi kalyan,

I went through your dashboard tab, i found for the company field  we have only 1 value. So its showing only one company name.

If i have understood the problem wrongly please correct me.

[krishna20]

Hi Avinash,

Pls find the screen shots.There is five companies.When i selected the company.Its placing there itself not moving to top.i sorted it by company name and then the unselected values showing zero for all results.

Pls find it in Screen shots.

Regards

Krishna