Pivot Function in Alteryx - Filter by Value by Ref (Multiple)

Hi Alteryx Community,

I would like to check on how to convert Pivot function to Alteryx -

Scenario: I have as set of data which consists of "Reference and Value" both have debit and credit amount. My filter in pivot is - filter by reference and value >0. To summarize, my output should showing only "Debit amount for each reference number".

Thanks in advance!

quims

Workflow

Datasets

Reporting

Output

Tips and Tricks

Best Practices

Help

Preparation

Accepted answers

AbhilashR

Hi @quims, you could introduce a filter tool to remove all the negative values. I have re-attached an updated version of my solution if it helps.

sample.yxmd

All comments

AbhilashR

Hi! Assuming your data is columnar in nature, would the attached skeleton of a solution work in your case?

The formula tool converts negative values into '0' and then the CrossTab structures it into a Pivot format. Let us know if this isn't what you are looking for.

sample.yxmd

quims

Hi @AbhilashR

Thank you for your reply but the "credit amount" should not be showing on final output.

In pivot function - i separate the credit and debit into two pivot based on reference.

-quims

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280