Data Issue

[nihhalmca]

Hi All,

I got one ticket on existing dashboard, it is new to me so i am seeking your assistance.

Pivot table has 10 columns and it display data in dashboard. However if i take selections on Year and Quarter 2 columns are shown 0 values rest of 8 columns shows data. i can understand it is not enough to solve issue but i can not explain detail (new application to me). Please suggest me.

Thank you.

Regards,

Nihhal.

[ThornOfCrowns]

Your best bet is to post the qvw with some dummy data if neccessary, as it's much easier to see the problem that way.

[jagan]

Hi Nihhal,

What are the expressions using in that 2 columns?  It is very difficult to say without the sample file, attach some sample file.  If the file you are working is of confidential then scramble the numbers and then share.  You can scramble the data by using

Document Properties -> Scrambling -> Select the field and click on Scramble button.

Regards,

Jagan.

[nihhalmca]

Expression is simple as sum(amount)

[nihhalmca · Accepted solution]

Hi Jagan, thanks for writing and i resolved this issue with help of teammate.

thanks,

Nihhal.