how to get al values in only one row after using cross tab

Question

Hi,

I need your help.

I need to get a formula: PPC Net (PPC-CTR-LRMI) and PPC Net Plus (PPC-CTR-LRMI-Steel). But we do not have the market effect "Steel".

I transform my levers (PPC, MCP, VAM, etc) and Market Effects (CTR, LRMI, Steel). and after that I used the formula to get the value of PPC Net and PPC Net Plus.

But is not working cause they are not in the same row. Are in different rows...I have several LCs and several countries. I just attaching an example about my problem.

Cause at the end. I cannot get my values correctly, cause they are not in the same row...please filter the month in 3.

I noticed that the DIs are doing noise there too...seems that when PPC values appear is DIs 5.

How can I transform that, after the formula of PPC Net and PPC Net Plus are correctly done? or how to get all values in only one row.

example: reporting unit PA GOA. PPC is 262.3 and CTR -263-2 and LRMI is -45.6...PPC Net should be 44.73. And I get only the sum of CTR and LRMI = -308.87

Flow is attached.

Thank you

PA_GOA.yxmd

caltang · Answer

@maxtla Thanks for the input file, but your ask is still quite confusing. Please can you standardize your query - what are you trying to do and show us an example via Excel, then it can guide a better solution on Alteryx.

maxtla · Answer

Hi, trying to add the input and the flow again...do not know how to export it...I just browse and add them...hope will work for you. many thanks

TEST_PA_GOA_INPUT.xlsx

PA_GOA.yxmd

caltang · Answer

Please EXPORT your workflow. We can't see your input file.

Select Options > Export Workflow

https://help.alteryx.com/current/en/designer/workflows/workflow-management.html#workflow-management

https://knowledge.alteryx.com/index/s/article/Export-Workflows-with-Attachments-Assets-1583460627828

@maxtla