Render Output

[ArijitRoy]

Hi Friends,

I need help on Render. I have attached a test excel file. It contains no data but have 3 sheets as Monday, Tuesday & Wednesday. It is the Output file.

Q1. Now If I have a input file with a data and that I want to render on the output file, like on the Wednesday sheet. After rendering output file should have all 3 sheets.

Q2. Have a summarize to doing sum for the amount column and want to render on the excel sheet, suppose on Tuesday sheet on column T and Row 1 (T1). How I can do that.

Q3, Also, how to render the amount from column A2.

Can someone help me? 

[rzdodson]

@ArijitRoy please attach sample data to this thread so the Community can aid in building a workflow that supports your requirements.

[ArijitRoy]

I have attached the sample file. First sheet have the data. Second sheet is the output what I am looking for and on the test file keeping all the sheets in it.

[ArijitRoy]

Hi @rzdodson, I have attached the sample data. Is it possible to get the Output via Render?

[binuacs]

@ArijitRoy Some thing like this?

[ArijitRoy]

Hi @binuacs,

The total should come above the header. I have rectified the solution for that. I have added some columns via formula. Suppose I need the total at C1 so I will add 2 empty columns via Formula and third column will be the Total column. 

Kindly check the Workflow that I have prepared. Now I have a graph also on my data but on output the column width size is like 255. Why this is happening? Any idea?

[binuacs]

@ArijitRoy Change the layout width in the Layout tool and also the custom paper size in the render tool