Having Dynamic Values in excel file along with text desription

[ferha_jafri]

Hello Experts,

I want to generate an output in the after the table in excel text should pop up as Footer and that has summation of values as I have attached in excel sample. So I was text at the bottom of the output excel in which the value will change as the sale value change.

Thanks in advance 

[atcodedog05]

Hi @ferha_jafri 

Is date also dynamic in the footer ?

[atcodedog05 · Accepted solution]

Hi @ferha_jafri 

Here is how you can do it.

Workflow:

1. Using summarize tool i am calculating sum of sales & price. And setting ID as Total using formula tool.

2. Taking sum of sales and todays date formatted i generating the footer.

3. Using union tool i am positioning one below other.

Output:

Hope this helps 🙂