Please help to construt the graph within the table
I have data on Accounts receivable balance over the period. I need to show graphically openning balance, closing balance and to-date balance. For example,
|Header 1||Header 2||Header 3||Header 4|
Let's say, in "Header 5", there should be graphical movement of abovestated balances.
It would better if you provide sample output in tabular format for [Header 5]
It's clear that I can use minibars but I have no idea how to tailor to this particular case described. Because I need to show the points on graphs of several fields...
The requirement as follows
I have several fields with figures as stated above "headers 2,3,4". I need to construct minibar in header "header 5" as I have attached pic. Please describe the formula to fulfill this.
Yes, but I cannot understand how to make "value" field. I have input data as follows:
I need somehow make crosstable?
Could you please help how to make "value" field from
[BB, Сальдо на начало],
[EB, Сальдо на конец],
[Сальдо на конец].
since I have different sources...
|[BB, Сальдо на начало],|
|[EB, Сальдо на конец],|
FROM [0_ISS\Processed\ProcPopulation 31.12.2016.xlsx] (ooxml, embedded labels, table is Sheet1);
Load * , If(Оплачено=0,0,1) as Flag;
|Company as [Company name],|
|Region as Region,|
|[Сальдо на начало],|
|[Сальдо на конец],|
FROM [0_ISS\Processed\ProcPopulation 01.01.2017-20.05.2017.xlsx]
(ooxml, embedded labels, table is Sheet1);