I have sales data by weekending with multiple records for a week with multiple weeks and I am not clear on:
(1) how do I add a GRAND TOTAL line.
(2) How do I add Sub-Totals by week.
My COLUMN(1) is Week Ending Date.
Is there a way to assigned a DATE column for another table of valid Week Ending Dates to avoid "wrong" dates? I got STATUS codes and REP codes to pull from a child table, but couldn't get a Week Ending (DATE) field to pull froma child table of valid week ending dates.
If I understand your question correctly you could use calculation functions ( https://wpdatatables.com/documentation/table-features/calculation-functions/ ) to display the total for each column, but I will have to ask you explain a bit more or provide me with an example of what you would like to achieve for the second part of the question.
I have sales data by weekending with multiple records for a week with multiple weeks and I am not clear on:
(1) how do I add a GRAND TOTAL line.
(2) How do I add Sub-Totals by week.
My COLUMN(1) is Week Ending Date.
Is there a way to assigned a DATE column for another table of valid Week Ending Dates to avoid "wrong" dates? I got STATUS codes and REP codes to pull from a child table, but couldn't get a Week Ending (DATE) field to pull froma child table of valid week ending dates.
Hi David
Thank you for reaching out to us.
If I understand your question correctly you could use calculation functions ( https://wpdatatables.com/documentation/table-features/calculation-functions/ ) to display the total for each column, but I will have to ask you explain a bit more or provide me with an example of what you would like to achieve for the second part of the question.