在您在 jsfiddle 中提供的代碼中，您似乎沒有添加僅添加唯一數據的條件。然后作為解決方案，您可以嘗試使用以下代碼：
$(document).ready(function() {
$('#example').DataTable({
"footerCallback": function(row, data, start) {
var api = this.api();
var intVal = function(i) {
return typeof i === 'string' ?
i.replace(/[\$,]/g, '') * 1 :
typeof i === 'number' ?
i : 0;
};
var indexOfPortofolio = 1;
var indexOfSymbol = 2;
var indexOfValue = 3;
// Total over all pages
var total = api
.rows()
.data()
.toArray()
.reduce(function(a, v, i) {
var uniquePortofolioSymbol = v[indexOfPortofolio] + v[indexOfSymbol];
if (a.uniqueList.indexOf(uniquePortofolioSymbol) === -1) {
a.sum += intVal(v[indexOfValue]);
a.uniqueList.push(uniquePortofolioSymbol);
a.uniqueIndex.push(i);
}
return a;
}, { sum: 0, uniqueList: [], uniqueIndex: [] });
// Total over this page
var pageTotal = api
.rows({ page: 'current' })
.data()
.toArray()
.reduce(function(a, v, i) {
var uniquePortofolioSymbol = v[indexOfPortofolio] + v[indexOfSymbol];
if (
a.uniqueList.indexOf(uniquePortofolioSymbol) === -1
&& total.uniqueIndex.indexOf(start + i) !== -1
) {
a.sum += intVal(v[indexOfValue]);
a.uniqueList.push(uniquePortofolioSymbol);
}
return a;
}, { sum: 0, uniqueList: [] });
// Update footer
$(api.column(3).footer()).html(
pageTotal.sum + ' ( ' + total.sum + ' )'
);
}
});
});
<link rel="stylesheet" href="https://cdn.datatables.net/1.10.22/css/jquery.dataTables.min.css">
<script src="https://code.jquery.com/jquery-3.5.1.js"></script>
<script src="https://cdn.datatables.net/1.10.22/js/jquery.dataTables.min.js"></script>
<table id="example" class="display" style="width:100%">
<thead>
<tr>
<th>Date</th>
<th>Portfolio</th>
<th>Symbol</th>
<th>Value</th>
<th>Payment</th>
</tr>
</thead>
<tbody>
<tr>
<td>2020-11-30</td>
<td>ISA</td>
<td>RLSEB</td>
<td>30000</td>
<td>30</td>
</tr>
<tr>
<td>2021-06-30</td>
<td>ISA</td>
<td>GSK</td>
<td>44000</td>
<td>30</td>
</tr>
<tr>
<td>2020-11-30</td>
<td>ISA</td>
<td>GSK</td>
<td>44000</td>
<td>30</td>
</tr>
<tr>
<td>2020-11-27</td>
<td>DEA</td>
<td>GSK</td>
<td>26000</td>
<td>30</td>
</tr>
<tr>
<td>2021-02-30</td>
<td>ISA</td>
<td>RLSEB</td>
<td>30000</td>
<td>50</td>
</tr>
<tr>
<td>2021-05-30</td>
<td>ISA</td>
<td>RLSEB</td>
<td>30000</td>
<td>54</td>
</tr>
<tr>
<td>2021-05-30</td>
<td>ISA</td>
<td>RLSEB</td>
<td>30000</td>
<td>57</td>
</tr>
<tr>
<td>2021-05-30</td>
<td>DEA</td>
<td>RLSEB</td>
<td>20000</td>
<td>27</td>
</tr>
<tr>
<td>2021-05-30</td>
<td>DEA</td>
<td>RLSEB</td>
<td>20000</td>
<td>27</td>
</tr>
<tr>
<td>2021-05-30</td>
<td>ISA</td>
<td>RLSEB</td>
<td>30000</td>
<td>31</td>
</tr>
<tr>
<td>2021-05-30</td>
<td>DEA</td>
<td>RLSEB</td>
<td>20000</td>
<td>22</td>
</tr>
</tbody>
<tfoot>
<tr>
<th colspan="3" style="text-align:right">Total:</th>
<th></th>
</tr>
</tfoot>
</table>
