Alteryx Reporting Table Tool

[arsh011]

I want to color the specific cells in  my report table on the condition of increasing and decreasing, as increasing quantity shows

with green color and the decreasing quantity with red color, but the columns headers are in form of months with years like

(Feb 2022,Mar 2022, etc) these headers change dynamically, how we can apply conditions with color in these headers that are changing dynamically.

Manually doing is taking too much time and when a new year header comes the condition does not affect that. Please help me !!!

color these quantities green for positive values and red for negative values for each cell.

the headers are like these dates 

how to give conditions that affect each cell as per quantities using reporting table tool.

[atcodedog05]

Hi @arsh011 

Can you provide some sample input and expected output It will help us get a better understanding of the usecase.

We will be happy to help : )

[arsh011]

sample input and desired output

[atcodedog05 · Accepted solution]

Hi @arsh011 

Here is how you can do it.

Workflow:

Output:

Hope this helps : )

[arsh011]

Thanks a lot, man!!!  it works but after rendering the excel the margins are gone and empty cells will contain zero with red color , we don't need that, how can we fix the margins? 

and what if our sample input has the same material 2 or 3 times?

[atcodedog05 · Accepted solution]

Hi @arsh011 

I am not clear about the issue. Please find the workflow for multiple categories.

Hope this helps : )

[arsh011]

Thanks again, Actually, after rendering the report in an excel file the empty cells show 0 as a value.

 we don't need 0 in empty cells.

[arsh011]

Hi @atcodedog05

How can I remove these zeroes that are showing in empty cells when I render the report in Excel.

The sample image is in above message.

[atcodedog05]

Hi @arsh011 

I can am not getting that issue can you provide a sample scenario where you are facing that issue.

[arsh011]

Thanks for support man, but the issue is when I output my report using render tool, where there is data positive or negative is fine,

but where there is no data or empty cells , the empty cells in the report show zeroes. I only want to show empty cells instead of zero.

In this image, the value is only in the month of May and the rest of months values are empty , so the empty cells showing 0 as a value , i only need empty cells instead of 0 , no need of showing 0 , how can i remove handle this problem?