Dynamic summarize for value

[neromerob]

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

[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

[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 · Accepted solution]

@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)