Hello,
Is it possible to take coloured text from a Report Text tool and then embed this within another Report Text tool? I have put a basic visual below, but imagine we have multiple records with the options of 'up' 'down' and 'flat', therefore I can't just use the first Report Text tool to accomplish this as I need to join the variations - see more in the attachment.
If there is a tidier way of filtering out and formatting the data, then this is also welcomed!
Text Input
| Last Week |
| Up 15% |
Report Text
| Text Data |
| [Last Week:A] |
Report Text 2
| Text Data |
| Sales were [Last Week:A] |
Browse Tool - Desired Output
| Last Week |
| Sales were up 15% |
Thanks,
Joe
