Forum Discussion
Shloka_Lakhani
2 years agoFrequent Visitor
How to create dynamic Pivot table
Hello All, I want table like this jan | feb | march | total | YTD GBV $123,456 | $56783 | $842567 | $1022806 | $206754 Bookings 23 | 65 | ...
nareshr89
Helper II
2 years agoIf Month is coming from Data table it might not be possible, but if you have a Dim_table with Month Names alone then you can try by using IF condition and adding a new row along with Month names something like YTD or TOTAL. Also, what is the difference between YTD & TOTAL in your view.