Hello all, I am a newbie to tableau and desperately help with something I think is relatively easy. See screenshot below. My data is coming from Microsoft Analysis server. I want to create a simple Text table to show the total earnings for an employee for the last couple years. Q1 - I need to show a total for each earning by year. Note show row totals does not work. Q2. I need to group a couple of earnings and show it as a total. Note the Group option is not available as I understand this feature is not available when connected to server.
Any suggestions/advice on how I can go about doing this?