Creating Analysis for Office Workbook where only two key figures are by Cost Center.

[joao_dias1175_5]

Hello everyone,

I'm creating an Analysis for Office Planning Workbook where i want to display only the KeyFigures Quatidade and Ponderado by Cost Center, and Peso not.

When i place the characteristic for CostCenter in the columns with the key figures, Peso is sorted by CostCenter too. I've tried to restrict the KF, but it still replicating.

Take a look.

Actual scenario:

Desired scenario:

I want to enter value for Peso and assign it for all Cost Centers displayed. The KF Ponderado is a calculated kf (Peso*Quantidade).How can i display like the second image?Thanks in Advance.

[former_member292810]

Hi,

You can do this by grouping crosstabs. First, you need to duplicate your query data source. In the second data source, only Peso must remain as a measure.

Regards,

from Sap help documentation :

Grouping crosstabs

You can now stick two crosstabs together so that they look and behave as they would be one crosstab. Therefore you have to group these crosstabs.

With grouping crosstabs, they are moved close together that there is no space in between. Furthermore the row axis is building the common axis of this grouped crosstab. The crosstab from which you trigger the grouping is defined as master and determines the structure of the common crosstab, whereas the dependent crosstab is providing its column axis.

[joao_dias1175_5]

Hello Yilmaz,

I had tried to do this, but if i duplicate my query data source i have to place the Cost Center in the second DS too, otherwise it doesn't allow me to input values.

I need a way to input the value for Peso and assign it to the Cost Centers that are in my first crosstab. Is it possible?

Thanks,

João Dias