Problem with PIVOT TABLE

[#1]

Hi community.

I have created a table with this statement:

SOLDE:
LOAD GROUPE,
GROUPE_BILAN,
GROUPE_COMPTE
RESIDENT INTER;

I have checked the contents of this table, by displaying the content in a simple table object.

But my problem is that : I want to displays these data in a pivot table.

When i create the pivot table, i select table SOLDE, in a list, i define the properties of pivot table,

the data are not displaying.

I don't know why?

Please i'm waiting for your help.

thanks.

[deepakk]

hi,

You need to add an expression to get value in Pivot table like sum(Amount) or type 1 in expression and check if the values are getting displayed or not.

[#3]

Thanks DEEPAK

But without an expression, we can't display a pivot table? why?

[deepakk]

We can only use Table box without expression.

We cant use pivot or straight table without expression because its used for aggregating values based on the added dimensions.

[#5]

Hi,

As Deepak said We cant use pivot or straight table without expression because its used for aggregating values based on the added dimensions.

But as the Work around or if you are sure that only values are there for dimension then u can use the Min or Max functions.

For ex: if your table is like this

City Count

A 200

B 300

You can use the pivot table expression min(Count) and the dimension as city.

But still you can use the table box itself .

[suniljain]

The pivot table presents dimensions and expressions in table form. There is no formal limit to the number of dimensions or expressions possible.

A pivot table can be defined without expressions, generating a tree view for navigating the dimension levels.

[#7]

But SUNIL, i have created a pivot table without expression.

The data have not shown.

Why???

[suniljain]

put any single charater in expression. it will show only pivoting

[#9]

Hi,

You can add the expression as 1 or count(1) or any character as sunil said .it will work.

[#10]

HI,

if you are working on Pivot / Straight , it is mandatory to have atleast i measure/ expression.

As sunil and XXX sugessted ,Try this value will come in your table.