Having Dynamic Values in excel file along with text desription

Question

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

LevelSample.xlsx

atcodedog05 · Accepted Answer

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 🙂