Hi all
I am still relatively new to Tableau +- 2 weeks, I would like to create a bar graph that displays sales% for the current week versus previous week.
I have the date formula for WTD and PWTD sorted, where I am struggling now is the product sales requirement Sales= netsales for specific prod / Total netsales (all products). this is one sheet eg....
If anyone can help point me in the right direction on how to achieve this I would be really grateful.
Hi Dan
I managed to come right by Duplicating my data source and then removing the product name filter from the relationship.
I then created a calculated field sum(netsales(filter)) / sum(netsale(duplicate no filer)) this gave the correct values.
I am now trying to add the bar for target but it creates 2, one for last week and one for current
regards,
