Listbox calculated dimension

[#1]

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

[tresesco]

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)

[ngulliver]

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

[#4 · Accepted solution]

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

Thank you Neil

Answer to : tres qv

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

[#5]

I done it, thank you a lot Neil

[ngulliver]

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

[#7]

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?

[ngulliver]

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