Adding Subtotal and Total in the cross tab
i have a problem with the layout of the Report. Here the report that i already made:
so we have cross tab --> BI category-sub-value(mtd) - target and achievment(vs tgt)
and here the layout of user requested :
so based on the requested. you can see the mark for subtotal in each of category. Total for Laundry , Noodles and Etc in the left of the layout. Which the standard function of total and subtotal yellowfin will add in the right place.
so i tried to create calculated field for this case:
the value is correct but when i try to put to the layout it adds to all the category and sub category:
Can anyone give me a solution ?