hide column data but show total

[userid128223]

I have pivot table that show 3 columns of expression.

Time_Purchased    Hours_Worked    Time_Remaining

I have break on pivot table to show subtotals at comany level.

I want to hide time remaining for indvidual rows but still show time Remaining under subtotals.

When I make text color white() for that field total also gets changed.

Any insight on how I can achieve this.

thanks

[swuehl]

You should be able to use dimensionality() (or secondarydimensionality(), if pivoted) function to check if the expression is evaluated in a (sub)total context. Create a new expression

=dimensionality()

or check the HELP on what is returned in each level of dimensionality. Then use something like

=if(dimensionality() < 2, sum(Time_Remaining), '')

[userid128223]

I have expression like below. how can i hide displaying each field an only display when it totals by company.

=Sum({$<BILLABLE = {'T'}, TimePurchaseDate = {'>=$(=ADDMONTHS(TODAY(),-12))'}>}TimePurchasedHours) - Sum({$<BILLABLE = {'T'}, ServiceDate = {'>=$(=ADDMONTHS(TODAY(),-12))'}>}HoursWorked)

[#4]

Hi animu ,

You go to properties->Presentation->

select the column name and click on hide column

[userid128223]

That will hide entire field, which I dont want to do. I want Time Remaining field to be displayed however hide the calculation in that field for individual column and only show sub totals displayed for company.

thanks

[IAMDV]

Please post your QVW file with Stefan's example and we'll mock up an example for you.

Thanks,

DV

www.QlikShare.com