show all the dimension in a table

[adiarnon]

i have a sales table/

one of the columns is product.

i have a filter (list box) of agent.

if i selecting an agent the table shows only the product that the agent sale.

if i want that the table will show all the products after i selected the agent.

if the agent sale the products i will see the data about them,

and for the product he didnt sale i will see nulls.

how can i do that?

[stabben23]

Hi,

if it is a straight table, add a dimenssion like sum({1}1), then you can hide it in presentation tab.

If it is a pivot use "your expression" +sum({1} 0)

//Staffan

[adiarnon]

its not working...

i add a dimension like you said

its say- error in calc

[stabben23]

hi, use (sum total{1} 1)

[adiarnon]

its working!!!!

tnx