Shared Variable in Crosstab

[former_member366557]

hi sir,

is it possible to use a shared variable in crosstab.

can you pleasse help me how sir/mam, iam stuck on this..issue..

maybe cant create a report without this  SCN.SAP.COM because most of my reports i created is based on your response guys...

thank you

regards

silent

[abhilash_kumar]

Hi Silent,

Could you provide more info about you're trying to do with the crosstab?

Where are the shared variables coming from?

How do you want these values to be used in the crosstab?

-Abhilash

[former_member366557]

i have a formula needs shared variable for me to summarize the value :

like this:

((Maximum ({@20FR}, {OINV.NumAtCard})+ Maximum ({@20OT}, {OINV.NumAtCard})+

   Maximum ({@20Reefer}, {OINV.NumAtCard})+Maximum ({@20STD}, {OINV.NumAtCard})) +

((Maximum ({@40FR}, {OINV.NumAtCard})+

    Maximum ({@40HC}, {OINV.NumAtCard})+

        Maximum ({@40HCReefer}, {OINV.NumAtCard})+

            Maximum ({@40OT}, {OINV.NumAtCard})+

                Maximum ({@40reefer}, {OINV.NumAtCard})+

                        Maximum ({@40STD}, {OINV.NumAtCard}))*2))

to get the sum of this formula i used shared variable in main report:

then the total of this which is the shared valiable i want to put it on the crosstab summarize portion..

thank you sir

regards

silent

[abhilash_kumar]

A crosstab could have multiple rows and columns.

This formula would result in a single value.

How do you wish to use it inside a crosstab?

Do you have some data as well?

-Abhilash

[former_member366557]

iam sorry i not familiar with this:  in relation to this sir here is my table linking

i try to summarize first the 20s here

and summarize 40 here

sum up here the 20 + 40 here

but the output  in 20 and 40 are zero same with the totalteu column

plaease help i am stuck here.... i dont know whats next...  thats why on my first screenshot i used maximum then to get total the of maximum i used a shared variable ..

thaats why iam asking also if posible to use shared variable in crosstab.

thank you

regards

silent

[abhilash_kumar]

Hi Silent,

Do you have any rows where the Account = 4027 and Cancelled = 'N'?

Could you drag and drop those two fields on the details section and see what data they have in them?

-Abhilash

[former_member366557]

sir  here is the result:

i think sir the problem now how can i total all 20 and 40s then grand totalteus

- i dont know how..

regards

silent