Straight table

[paulwalker]

Hi Community,

this is my table....

LOAD * INLINE [

    Category, Product, Cost

    A, A1, 100

    A, A2, 200

    A, A3, 300

    B, BA, 400

    B, AB, 500

];

My requirement...

When i making selection Category, in straight table i want to show full data but

Suppose if i am click Category A, only i want populate associate data for Category A.  remaining should be Zero in straight table.

Thanks in Advance..

[tamilarasu · Accepted solution]

Hi Paul,

Like attached.?

[Anil_Babu_Samineni]

I am not sure, what are you acheiving

But why not simply creation of Straight Table

Product - Dim

Cost - Expression

Then uncheck the suppress Zero-Values from Presentation tab and then choose Null Symbol "0" Then try.

[paulwalker]

it's very simple

Anyway thanks

[rajpreeths]

Hi Tamil,

Could you please share me how did you implement this ????

Br,

Rajpreeth S

[tamilarasu]

Hi Rajpreeth,

Goto dimenion tab and enable "Suppress When Value Is Null" and "Show All Values" options for the specific dimension. After that goto presentation tab and untick the "Supress Zero-Values" option. That's all.

I missed to explain this procedure in my previous post.

[rajpreeths]

Thank you Tamil