on 2020 May 02 12:24 AM
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:
Request clarification before answering.
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 :
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
78 | |
12 | |
9 | |
8 | |
7 | |
5 | |
4 | |
4 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.