Dynamic summarize for value

Hello everyone

Let´s suppose that I have the following workflow and that the data is not in a file but in a database.

Now in this file the month are already fixed, and therefore the summarize, cross tap tools will work just fine.

But in the scenario that another month appears, I would have to modified the tools ins order to consider that.

Is there a way to actually use a “dynamic summary” one that considers the existence of a new value, in this case, month.

Thank you

test_database.xlsx

test_summarize.yxmd

Workflow

Datasets

Input

Reporting

Output

Help

Dynamic Processing

Accepted answers

binu_acs

@neromerob If you take a look at the cross tab tool output and the summarize tool output both are same, only the column names different, I think you dont need the summarize tool to do the calculation, which is already dong the cross tab tool (note :you can remove the formula tool as well)

All comments

binu_acs

@neromerob I updated your workflow by removing the summarise tool. Can you check you are getting the desired result and it should be dynamic

test_summarize.yxmd

neromerob

hello @binu_acs

thank you for your fast response.

but there´s something that i don´t understand, the summarize tool will add new info that exist in the database? i ask because my real workflow operates a tool like this

so what I don't know is if the summary tool will consider eventually the existence of month seven, if not, what can i do to make it dynamic and get "month 7" into the summary tool as a group by?

than you.

binu_acs

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335