Table with Total Function Columns

[#1]

Hi,

I'm creating a table something like this:

"Product"       

"Region"        

"Product Region Sales" ------------------------ sum(Sales)    

"All Product Region Sales" ------------------- sum(total<Region>{<Product>}Sales)   

"Product National Sales" ---------------------- sum(total<Product>Sales)  

"All Product Region Sales" ------------------- sum(total{<Product=>}Sales)

The values are OK, but when I select a Product, I want the lines from the other products to disapear because the "Product Region Sales" and "Product National Sales" are equal to 0.

What should I do?

Thanks in advance,

Francisco.

[PrashantSangle]

Hi,

I am not sure what you want but as per my understanding,

You don't want to show "Product Region Sales" and "Product National Sales" if Product is selected

then,

You Can try Conditional Column.

Write

If(getSelectedCount(Product)<1) for those column.

Regards,

[#3]

Imagine I have Product A and B, with no selection table is OK, but the problem is when I select Product A this happens this:

The problem is when I select Product A this happens this:

Product          Region         Sales                  Regional Market           National Sales        National Market Sales

A                    1                    10                              50                         200                         1000    

A                    2                    5                                10                         75                           1000

B                    1                    0                                50                         0                             1000

B                   2                    0                                10                          0                             1000

Because I select product A, the Sales (Regional and National) of product B are 0 and I don´t want  the lines from Product B appear on the table.

Was I clear?

Thanks,

F

[#4]

What kind of table are you using?  A pivot table should do that for you

[#5 · Accepted solution]

Thanks Robert for your post...

I resolved my problem with Dimension Limits.

Regards,

F