as explained in other posts on this community you can only mimic pivot table look & feel. It depends on number of dimensions, required subtotals, dimensions as columns, number of values in those dimensions, variability of values and so on. there is no “one size fits all” recipe and solution depends on very particular requirement you may have.
cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.