Calculated Rows in a table

[hellojb]

Is there any way to create a table with calculated fields for each category? I need to create a table that uses other attributes to calculate the projected sales of tickets for each quarter.  Each row is calcualted differently.

I know this is possible using measures but I need to show the trends using a line chart. 

data table (with calculated fields)

Category	Current	Q1	Q2	Q3	Q4
student	100	105	120	110	120
senior	80	75	80	85	85
adult	120	125	130	140	150
child	90	100	120	110	120

[v-chenwuz-msft]

Hi @hellojb ,

What does the expect output looks like? please put result here for reference.

Best Regards

Community Support Team _ chenwu zhu