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