7 Replies Latest reply: Aug 14, 2013 4:08 AM by Neil Gulliver

# Listbox calculated dimension

Dear all,

We want to have simple list box, where the names of the departments are visible, but only those which haven't sent their reports to the management. We havent got in the data model such a column, which has been already counted. So we must somehow write it in the expression, but the names ... can't be sum or.. something like this

how can we do it?

give me some idea

• ###### Re: Listbox calculated dimension

There has to be some logic how you decide that the department has sent report to management or not, based on that you can populate your listbox. list box expression might look like:

If( <condition>, Department) , or

if( ReportSentFlag='Y', Department)

• ###### Re: Listbox calculated dimension

If I understand you correctly, instead of using a List box you can try to use a Chart Object\Straight Table.

This gives you the ability to use set analysis in your expression to narrow the range of data being returned. You can then hide all the expression column in the Presentation tab leaving you with the one column listing the department names.

Regards,

Neil

• ###### Re: Listbox calculated dimension

it sounds great, just could you tell me how to hide the second column. I done the strait table already.

Thank you Neil

- it doest work Tres, i try your proposal, but it doesn't work.

• ###### Re: Listbox calculated dimension

I done it, thank you a lot Neil

• ###### Re: Listbox calculated dimension

Hi,

You can hide the columns in the Presentation tab. In the top left corner you have a list of the columns. Below this are the options to show or hide a column.

Click on each field a choose whether to hide or show them.

Regards,

Neil

• ###### Re: Listbox calculated dimension

and last question Neil, thank you a lot for the previous.

I want to show me only the reports for the last month year, which was choosen from my calendar, so i wrote this expression :  count({<MonthYear = {\$(=max(MonthYear))}, Key = {2}>}Key)

but it doesn't work .... Is my logic right?

• ###### Re: Listbox calculated dimension

I'm not sure without understanding your data better. You're missing the ' around the selection.

I would probably use sum({<MonthYear={'\$(=addmonths(max(MonthYear), -1)'}>}Key)

Regards,

Neil