Make columns appear at drilldown level

[#1]

Hi all,

is it possible to have columns appear only at drilldown level? My situation is some columns are irrelevant at the first level of drilldown, it is only relevant when i get to the lower level. Thanks.

[deepakk]

If you have using a straight table then it is possible to do so.You can hide the column based on Condition. Go to presenation you will find the option of hiding the column.

[#3]

thanks for that, i found the "hide column", but where do i enter the condition? What should the syntax be to indicate which level of drill down the column should apear?

[#4]

Hi Danny,

You can also control by macro.

upon select of a particular data in a field you can enable or disable the expression.

The below macro help to disable a expression

set chart = ActiveDocument.ActiveSheet.CreateStraightTable
chart.AddDimension "Customer"
chart.AddDimension "ProductType"
chart.AddExpression "sum(Amount)"
chart.AddExpression "count(Customer)"
set cp = chart.GetProperties
set expr = cp.Expressions.Item(0).Item(0).Data.ExpressionData
expr.Enable = false 'disable first expression
chart.SetProperties cp

Regards

Rajesh

[#5]

Hi,

Check the attached application.

Here i have pivot table , which shows sum of value when nothing is selected or with out drilldown. if you drill down to next level it will show count of value.

Expression has to be written in presentation tab of straight table and select the expression and choose conditional show option and write your expression.

Hope this will help you.

-Peterson

[#6]

You seem to have done that in QV 9, I cant see what you are saying, i cant write expressions in the presentation tab

[#7]

Works perfect for me thank you