Hi 

Can I combine calculated column and Placeholder like this

[wpdatatable_sum table_id=16 col_id=148 var1=2017]

it dosn't seem to work it only works on the table short code.

Hi,

I have a wpDataTable and I am using the shortcode for one of the column Totals. But I want to filter the data to use only 2018 for the year and give me the total gains.  I created a Placeholder %VAR1% and I want to pass var1 in the shortcode that I have for the column total.

 Here is my column total shortcode [wpdatatable_sum table_id=16 col_id=148]   <--- this was generated for me.  it works but it returns the total for all years.  I want the total for 2018.  So I thought I could pass it in by adding var1=2018... like this

[wpdatatable_sum table_id=16 col_id=148 var1=2017]    But it doesn't work I still get the total for every year.

 I can use it with the table shortcode as follows 
[wpdatatable id=16 table_view=regular var1=2017] <--- this works for the table.

My question is why doesn't it work when using a column total shortcode ?

BTW my data source is the follows

SELECT monthly_gain_loss.Month_Year,

       Y,
       monthly_gain_loss.Month_Year AS Month_Year_Name,
       monthly_gain_loss.Stock_Loss_Gain,
       monthly_gain_loss.Option_Income,
       monthly_gain_loss.Total_Loss_Gain
FROM monthly_gain_loss
WHERE Y > %VAR1%