Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HOW TO DO GROUPING IN STRAIGHT TABLE?
IN THIS IMAGE : I WANT TO GROUP DMIN,RA, SV UNDER AD AND DO ROLL UP.
CBU IS A DIMENSION.
CAN WE ACHIEVE THAT IN FRONT END?
For the sorting I think you can use in the sort tab of the properties, sort by expression something like
=wildmatch(CBU,'RA','SV',......othervalues)
For the +sign option, use a pivot table with two dimensions, the first where you do the grouping, second dimension CBU.
For clarity, can you please make a new thread for new questions?
OK
Can you explain in more detail.
Not sure for what you want more detail... but in general tab change the chart to pivot table instead of straight table, then the first dimension with the grouping expression and then add a second dimension with field CBU