This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

BUG: Pivot tables simply don't calculate correctly

Posted on 03-02-2025 09:27 AM
DSCZ
Bronze 2
Bronze 2
Reply posted on --/--/---- --:-- AM

Hello,

I'm dealing with Pivot table simply not calculating what is expected. I have sales data in MSSQL table, configured in data source. Time dimension contains whole timeline since i.e. 01.01.2023. I'm building pivot table, where I want simply see sales of every product, summarized on monthly basis. So my columns containt date in year-month format, rows contain products. Metrics is sum of sales. And... pivot table calculates correctly approx 90 products and then ... crashes or something. It shows correct "grand total", but data in respective months are "zeros".

DSCZ_0-1740936359303.png

I tried several different approaches, but in the end is seems as there is just certain limit of rows, which pivot table is able to calculate and then overflows.

Which makes this tool nearly unusable. Any chance to fix this soon?

 

0 1 78
Topic Labels
0 Likes
1 REPLY 1

Posted on --/--/---- --:-- AM
sam8
Staff
Reply posted on --/--/---- --:-- AM

For what it's worth, this doesn't sound like behavior I'm familiar with in Looker Studio. Are you sure that there isn't a filter limiting the data? Or a database limitation?

0 Likes
Top Labels in this Space
Top Solution Authors
View all