Show all values

[#1]

Hi *,

I'm trying to show all Sum values, even if they are Null for each Type.
This is working so far. As soon as I add a second dimension e.g. description (of Type),
I get every combination even if they don't exist. Is there a way to avoid this?

table should look like this:

Type Description Sum
1 Type_1 260
2 Type_2 100
3 Type_3 0
4 Type_4 0
5 Type_5 0
6 Type_6 0
7 Type_7 0
8 Type_8 0
9 Type_9 0
10 Type_10 0

The selection of a year should only change the sum field.

Anyone an idea?

Ps. Why is the last line of the table diagramm Type "-"

Thanks

[#2]

Is it what you wanted to achieve ?

I changed the script and some parameters in the table chart.

Philippe

[#3]

Hi Phillipe,

thanks for your help.

I'd like to display all types their description and the sum for each type, even if its null (all types should be shown).

If I select a year, the null values still should be shown.

[#4]

guess it's a problem to display values, selected by a date field when they actually don't exist and therefor no date filed exists.

[#5]

You could be able to generate a calendar to fill the missing records.

And then you will be able to show all the values you need.

Philippe