Hi, I don't know if I understood correctly but if you want to add one more row with the description "Total" then you can concatenate your tables like:
LOAD BrandName FROM... ;
LOAD * INLINE [
If what you want to sum up the brand then this is done in your fact table and not in your dimension table.
thanks for your reply,
Actually i want to show in my report 12 brands and total column that is in my pivot table.i am having only one expression in my table.
When i drag brand dimension in vertical position,the 12 brands having one expresion and for total i am having one expresion.
I thought that i will give expression for the brandname and in the same expression i will give another expression based on the if condition.
so i need to add one text as total in brandnames.
Follow these steps.
1 - On your pivot table --> Properties --> Presentation --> Click on the Brands dimension --> Label for Totals --> Input "Total".
2 - On the same Presentation window select 'Brands dimension' and there is a subsection called Subtotals, you can select Subtotals on top or bottom as per your requirement.
I hope this helps!