Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

How to keep columns in a summary pivot fixed when the columns are variable

KarenHM
7 - Meteor

Hi

I have a job and I created a formula with  IF (if any information in the data is "invoices NM" then "Invoices AP" ..... and then with this information i created a summary pivot , but now one o the field that I set up in the IF doesn't have information this period. At the end I have another formula that sum all the columns that has the summary pivot, but appear and error because this column doesn't exist this period. 

do you know how can fixed some columns in case that a specify period don't appear?

 

If 

KarenHM_0-1662396106243.png

 

This month dont appear Purchase invoices then AP Constab dont appear here

KarenHM_1-1662396253062.png

so I cant do this sum 

KarenHM_2-1662396299389.png

I appreciate the support that you can give me !

 

2 REPLIES 2
dougperez
12 - Quasar

You can try to use Multi-field formula tool with "dynamic or Unknown fields".

dougperez_2-1662404501500.png

 

dougperez_0-1662404458319.png

 

Qiu
21 - Polaris
21 - Polaris

@KarenHM 
There are maybe other more dynamic way of doing this, but should invove dramatic change of your current flow.
With minimun change, I think we can do like below given you have known your necessary columns.
Idea is add the missing column as empty column to the orginal data input.

0906-KarenHM.PNG

Labels
Top Solution Authors